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

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

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

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