Second largest value

[Kim Young]

How do I find the second largest value in a range of data? I have a list of
daily meter readings and need to subtract the second largest from the largest
to determine the daily usage.

 

[JulieD]

Hi Kim

use
=LARGE(A1:A100,2)

 

[Jason Morin]

=LARGE(A:A,2)

HTH
Jason
Atlanta, GA