| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Second lowest in 28
Thanks to 'Biff', I was able to get the lowest result based on the previous
28 cells... and I thought it would be easy to convert that array so that I could also get the second lowest in the same 28 cells. Not quite as easy as I thought. Can anyone help? The original was: {=MIN(W68:INDEX(W1:W68,LARGE(IF(W1:W68<"",ROW(1:6 8)),28)))} and this gave me the lowest in the range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
| Drop 3 Lowest Entries | Excel Worksheet Functions | |||
| how to subtract the very next LOWEST number | New Users to Excel | |||
| How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
| How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
Threaded Mode
