I have a sheet with three columns:
[Employee ID] (Distinct values)
[Start Date]
[Stop Date]
I need to search a second sheet with two columns:
[Employee ID] (Non-Distinct)
[Testing date]
and return the next greater [Testing date] than each [Stop Date] on the first sheet for each employee.
I am using latest Excel 365