Hello,
I created a formula to look up the most recent event name and date in a tracker. Was working great in examples 1 and 2 below, but ran into an issue when two events have the same greatest date.
In example 3 below I would want the latest date to say "Interview 2" on "2/1/24" (rather than Interview 1)
Is there a way to start the look up from right to left - or any other ideas to rework formula below?
Thank you!
I created a formula to look up the most recent event name and date in a tracker. Was working great in examples 1 and 2 below, but ran into an issue when two events have the same greatest date.
In example 3 below I would want the latest date to say "Interview 2" on "2/1/24" (rather than Interview 1)
Is there a way to start the look up from right to left - or any other ideas to rework formula below?
Thank you!
calc output (col A) | calc output (col B) | input (col C) | input (col D) | input (col E) | input (col F) | input (col G) | input (col H) | |
header | Latest Event Name | Latest Event Date | Event 1 Name | Event 1 Date | Event 2 Name | Event 2 Date | Event 3 Name | Event 3 Date |
example 1 | Interview 2 | 1/15/24 | Interview 1 | 1/1/24 | Interview 2 | 1/15/24 | ||
example 2 | Interview 1 | 1/10/24 | Interview 1 | 1/10/24 | ||||
example 3 | Interview 1 | 2/1/24 | Interview 1 | 2/1/24 | Interview 2 | 2/1/24 | ||
example 3 formulas | =INDEX(C4:H4,MATCH(B4,C4:H4,0)+1) | =MAX(B4:H4) |