On Sep 10, 2:07*pm, "T. Valko" wrote:
Here's another one...

Data in the range A1:A10

Enter this formula in C1:

=MIN(A1:A10)

Enter this array formula** in C2 and copy down until you get blanks:

=IF(OR(C$1:C1=MAX(A$1:A$10)),"",SMALL(A$1:A$10,SUM (COUNTIF(A$1:A$10,C$1:C1)*)+1))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP

"Basketball" wrote in message

...



Using the small function, is there a way with one formula to get a
list of unique small values.
If I had the following:
1
1
2
4
4
6
9
11
11
13

If I look up =small(a1:10,1) it gives me 1
If I look up =small(a1:10,2) it gives me 1

What I am looking for is a formula that will give me
1
2
4
6
9
11
13

Any help would be appreciated! Thanks in advance!- Hide quoted text -

- Show quoted text -

Thank you all for your help. I greatly appreciate it!