Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN to get three lowest
I'm not sure if this is possible. I have a spreadsheet with a set of values and I figured out how to get the lowest value by the following function: Code: -------------------- =MIN($E$193:$AI$193) -------------------- But how do I get the next two lowest? So I can have somewhat of a top 3 lowest numbers kind of a thing. -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=508409 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN to get three lowest
You can use the SMALL function...
= SMALL($E$193:$AI$193,2) and = SMALL($E$193:$AI$193,3) Hope this helps! In article , DKY wrote: I'm not sure if this is possible. I have a spreadsheet with a set of values and I figured out how to get the lowest value by the following function: Code: -------------------- =MIN($E$193:$AI$193) -------------------- But how do I get the next two lowest? So I can have somewhat of a top 3 lowest numbers kind of a thing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting lowest # if it only appears once | Excel Worksheet Functions | |||
"Drop the lowest" in computing average | Excel Worksheet Functions | |||
Second lowest in 28 | Excel Discussion (Misc queries) | |||
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |