max reference cooresponding cell
 

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?

max reference cooresponding cell
 

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

"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?

max reference cooresponding cell
 

=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?

max reference cooresponding cell
 

Thanks Duke! That did it! You're incredible!

Andy

"Duke Carey" wrote:

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

"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?

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?