| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
=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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
| Help with finding largest value | Excel Worksheet Functions | |||
| Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
| How do I sum 4 number discarding the largest number. | Excel Worksheet Functions | |||
Linear Mode
