XL-2007

=IFERROR(SMALL(IF(FREQUENCY(data,data)0,data),ROW S($1:1)),"")

ctrl+shift+enter, not just enter
copy down


Prior to XL-2007:

=IF(SUMPRODUCT(1/COUNTIF(data,data))=ROWS($1:1),SMALL(IF(FREQUENCY (data,data)0,data),ROWS($1:1)),"")

ctrl+shift+enter, not just enter
copy down


"Basketball" wrote:

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!