Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum but One??
Can anyone tell me how I can look up the "minimum but one" in a range of cells?? There must be a way Thanks in advance -- twogoodtwo ------------------------------------------------------------------------ twogoodtwo's Profile: http://www.excelforum.com/member.php...o&userid=12738 View this thread: http://www.excelforum.com/showthread...hreadid=489060 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum but One??
Use the SMALL() function
-- Kind regards, Niek Otten "twogoodtwo" wrote in message ... Can anyone tell me how I can look up the "minimum but one" in a range of cells?? There must be a way Thanks in advance -- twogoodtwo ------------------------------------------------------------------------ twogoodtwo's Profile: http://www.excelforum.com/member.php...o&userid=12738 View this thread: http://www.excelforum.com/showthread...hreadid=489060 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum but One??
If you want the minimum use
=SMALL(A1:A100,1) if you want the 2nd smallest value then use =SMALL(A1:A100,2) -- Gary''s Student "twogoodtwo" wrote: Can anyone tell me how I can look up the "minimum but one" in a range of cells?? There must be a way Thanks in advance -- twogoodtwo ------------------------------------------------------------------------ twogoodtwo's Profile: http://www.excelforum.com/member.php...o&userid=12738 View this thread: http://www.excelforum.com/showthread...hreadid=489060 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum but One??
Thanks so much!! -- twogoodtwo ------------------------------------------------------------------------ twogoodtwo's Profile: http://www.excelforum.com/member.php...o&userid=12738 View this thread: http://www.excelforum.com/showthread...hreadid=489060 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimum from various columns without zeroes | Excel Worksheet Functions | |||
second minimum value | Excel Discussion (Misc queries) | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
lookup - return minimum value | Excel Worksheet Functions | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |