|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 1st, 2005, 06:09 PM
|
|||
|
|||
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
April 1st, 2005, 06:15 PM
|
|||
|
|||
|
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
April 1st, 2005, 06:19 PM
|
|||
|
|||
|
=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. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| finding the largest number from the last row and look up its name. | Jeff | Worksheet Functions | 5 | February 24th, 2005 10:40 PM |
| How to display Col1 and Col5 for the largest 3 values of Col5 | Roger | Worksheet Functions | 2 | November 12th, 2003 10:19 PM |
Linear Mode
