Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Proper function/command?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    USA
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Warning : Newbie

    I have a list of numbers, from which I want to select the smallest n of x numbers of where n will equal 60% of the total numbers in the list. Or simply, I want the smallest 6 values out of a list of 10 numbers.
    I am familiar with the SMALL function and it works fine IF I have the requisite 10 numbers, but if I only have 5 then I get an error.

    Thanks

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about using the RANK function in the Analysis Toolpak?

    EDIT:: No that wont work. Sorry.

    _________________
    [b] Mark O'Brien

    [ This Message was edited by: Mark O'Brien on 2002-04-12 12:11 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    WA state
    Posts
    409
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    With your #'s in A1:A10, it sounds like you're using SMALL(A1:A10,6).
    Try SMALL(A1:A10,.6*COUNT(A1:A10)).

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use the AutoFilter. AutoFilter the range, and in the column you want to select the numbers, use "The top 10..."

    Once in there, choose "Lower", "6", "elements"

    you should get the lower six elements of the list.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-12 11:53, halbaker wrote:
    Warning : Newbie

    I have a list of numbers, from which I want to select the smallest n of x numbers of where n will equal 60% of the total numbers in the list. Or simply, I want the smallest 6 values out of a list of 10 numbers.
    I am familiar with the SMALL function and it works fine IF I have the requisite 10 numbers, but if I only have 5 then I get an error.

    Thanks
    Hal,

    Do you want the results listed, summed, or what?

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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