max reference cooresponding cell
THanks MAMA!
"Teethless mama" wrote:
=INDEX(A1:Y1, MATCH(MAX(A2:Y2),A2:Y2,0))
"Andy" wrote:
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?
|