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.