Try:

=MAX(IF(A1:A7<MAX(A1:A7),A1:A7))

Replace A1:A7 with the appropriate range. This is an array function and
must be confirmed w/ Cntrl+Shift+Enter instead of just hitting Enter after
keying it in.


"Joe" wrote:

I've got a series of increasing numbers (dates, actually) in a row. I use
=MAX to get the highest recorded date. Is there any way to get the second
highest date? If it helps, it will always be in the cell to the immediate
left of whichever cell qualifies to be the =MAX.


A B C D E
F
1 9-20-05 9-25-05 9-26-05 10-03-05
2
3

=MAX(A1:D1) should give me 10-03-05, right?

is there any way to return '9-26-05' or the cell to the left of the MAX?