Proper function/command?

[halbaker]

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

 

[Mark O'Brien]

How about using the RANK function in the Analysis Toolpak?

EDIT:: No that wont work. Sorry.

_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-04-12 12:11

 

[Scott R]

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

 

[Juan Pablo González]

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.

 

[Aladin Akyurek]

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