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
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
Use the SMALL() function
--
Kind regards,
Niek Otten
"twogoodtwo" <[email protected]> wrote
in message news:[email protected]...
>
> 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!!
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks