accessing a date cell adjacent to an Max field

  • Thread starter Thread starter AMP
  • Start date Start date
A

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
 
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
 
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 -
Click to expand...

Pete,
Great,
Thanks
Mike
 
Back
Top