Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function to select unique values... | Excel Discussion (Misc queries) | |||
Use criteria for values in range for small function | Excel Worksheet Functions | |||
What function to select the last 3 small values from a list ? | Excel Discussion (Misc queries) | |||
What function to select the last 3 small values from a list ? | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions |