Hi,

Select the range and then go to Data Filter Advanced Filter. IN the
list range, select the range, leave the criteria blank. In the copy to box,
give a cell reference and then check the box for unique records only. This
will extract all the unique records.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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!