View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Basketball Basketball is offline
external usenet poster
 
Posts: 2
Default 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!