MAX Foumula

C

carol

Hi,

I know that the 'MAX' formula can be used to look into a range and pick out
the most recent date.

Is it possible to use this formula to pick out the second most recent date?

Thanks for youe help.

Carol
 
P

Peo Sjoblom

Use LARGE

=LARGE(A2:A500,2)

will return the second highest number which would be the equivalent of the
second most recent date assuming that the dates are numerical excel dates
and not text strings

--


Regards,


Peo Sjoblom
 
R

Rick Rothstein \(MVP - VB\)

Use the LARGE function for that. For example (change the range to suit you
conditions)...

=LARGE(A1:Z3,2)

Rick
 
J

Jim Thomlinson

Use the Large formula

=Large(A1:A2, 2)

Will return the second largest value in cells A1:A10
 
Top