Small Function Unique Values
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!
|