Second largest value
 

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.

Hi Kim

use
=LARGE(A1:A100,2)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kim Young" <Kim wrote in message
...
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.

=LARGE(A:A,2)

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.