| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Second largest in array of difference in high-low values in cells
Using Excel 2002 to try to find second largest number from 10 numbers, which
are calculated from the high and low values of the day. Used Large Function but comes up with error even when I cut down the quantity of numbers. Example: 10-8=2.0 10.2-8=2.2 9.5-8.5=1.0 9.5-9.3=0.2 10.2-10.1=0.1 etc Correct answer would be 2.0 for the second largest number, but how do I get Excel to calculate this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference to the N-largest value in an array | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Find the difference between the high & low value of a given set. | Excel Discussion (Misc queries) | |||
| How to find the largest product of an array of values? | Excel Worksheet Functions | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
Threaded Mode
