accessing a date cell adjacent to an Max field

[AMP]

Hello,
I have a list dates and numbers in a sheet and I want to find the DATE
cell that is related to the number cell.
I could find the Max number but I only really want the corrisponding
date.
This is probobly 1st grade excel, but I've never done it.
Thanks,
Mike

 

[Pete_UK]

Suppose your dates are in column A and your numbers in column B. Try
this somewhere else (eg C1):

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Hope this helps.

Pete

 

[AMP]

Suppose your dates are in column A and your numbers in column B. Try
this somewhere else (eg C1):

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Hope this helps.

Pete



- Show quoted text -

Pete,
Great,
Thanks
Mike

 

[Pete_UK]

Glad to hear it, Mike - thanks for feeding back.

Pete