max reference cooresponding cell

A

Andy

Calling all Brilliant Excel veterans!

I have a row of 25+ cells with dates in them. I need a function that will
find the most recent date in the row and then reference the coresponding
label in the row above...

Is there a way?

I have used the max function and that will find the most recent date in the
row... Now how do I get it to reference the text label in the row above. In
other words, I need the function to scan the row for the most recent date and
then reference the coresponding cell above and populate the function cell
with the text/label.

Any advice? Does that make sense?
 
D

Duke Carey

Replace the ranges in here with your own ranges

=INDEX(G5:N5,,MATCH(MAX(G6:N6),G6:N6,0))

G5:N5 is the label range
G6:N6 is the date range
 
Top