No. I don't want second largest. I want second to last.

If there are a series of numbers: 1, 2, 4, 5, 5

The second to largest is 5 because 5 and 5 are two separate #'s. I only
want to identify the second (or 3rd or 4th to last).

"Ron Coderre" wrote:

This formula returns the 2nd largest number from A1:A100
=LARGE(A1:A100,2)

Is that something you can work with?

Regards,

Ron
Microsoft MVP (Excel)


"coolerthancool" wrote in message
...