Hello,
I'm trying to find a way to look up the date within the same sheet based on the value of a column. In the spreadsheet below, I want to find the end date of the phase listed in column C for each employee. The dates for each phase are listed in column F.
Thanks!
Solved! Go to Solution.
To find the MAXIMUM END Date by Current Phase for an employee,
I would use a summarize tool configured as:
GroupBy [Employee#]
GroupBy [Current Training Phase]
Max [End Date]
You could JOIN that data (right side of join) to the original data (left side of join) on:
Left Employee # = Right Employee #
Left Current Training Phase = Right Current Training Phase
That will populate MAX_End Date on the data.
I'm not certain by your question if this is exactly what you want, but it should help you get to your answer.
Thanks,
Mark
Thanks for the response.
That gave me the Date, but I need the date listed on each row in Column C.
This works! Thank you!