Function the finds the highest/lowest Nth numbers in a range

[KC2MF]

I know that the =MAX/=MIN function finds the highest/lowest number in a range. and that the =Large/=Small function finds the Nth highest/lowest number in a range. But what function can find the the highest/lowest Nth numbers from a range?

Thanks for the help for anyone who knows this.

 

[shg]

=large(a1:a10, {1,2,3,4,5}) returns the five largest numbers.

 

[ElmerFud]

I’m having a similar problem; I have a range of number in a column. Example: Column (B4:B273) with numbers going down the column 1,1,1,1,2,4,18,1,1,1,18,22,9,14,18,3,1,1 etc. etc. What I’m trying do is in a separate row going across, let say row (C335, D335, E335, F335, etc. etc.) is put the lowest number in the above range (B4:B273) in cell C335 which would be the lowest number (1), then the next cell D335 would be the next lower number(2), next cell E335 the number (3), then (4), (9), (14), (18), and so on. It needs to skip the repeated numbers in the range. Max & Min, Small & Large work on the first three or so and that’s it, won’t go any further. Can someone help with this easy formula to get it to work correctly? Thanks~
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>