MAX Foumula

[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

 

[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

 

[Rick Rothstein \(MVP - VB\)]

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

=LARGE(A1:Z3,2)

Rick

 

[Jim Thomlinson]

Use the Large formula

=Large(A1:A2, 2)

Will return the second largest value in cells A1:A10