+ Reply to Thread
Results 1 to 4 of 4

Minimum but One??

  1. #1
    Registered User
    Join Date
    08-05-2004
    Posts
    18

    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

  2. #2
    Niek Otten
    Guest

    Re: Minimum but One??

    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
    >




  3. #3
    Registered User
    Join Date
    08-05-2004
    Posts
    18
    Thanks so much!!

  4. #4
    Gary''s Student
    Guest

    RE: 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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1