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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com