Find & Display Unique Values

[dreicer_Jarr]

What's the formula that will search a column of values and "pull out" only one of each unique instance? The expected result, then, for the following data-set would be 4,5,6,7,8,9.

4
4
4
4
4
5
5
5
6
6
6
6
6
6
7
7
8
9
9
9
9
9

Thank you ,

D

[arthurbr]

Try Data - Advanced Filter and follow the wizard
Don't forget to check "unique records only"

[zbor]

or try this:

Unique_values.xls

[dreicer_Jarr]

The second solution (the one that does not use filters) is more what I am looking for in that the report I am creating uses continual pasting and automatic updating...so I need a formula.

However, is there a more simple solution? I don't mind using the longer (some might say more complex) formula, but my gut tells me there is something more simple out there...?

Additional help? And thanks to both of you...I have provided feedback.

[martindwilson]

if you dont mind blanks in the result you can simply use
=IF(COUNTIF($A1:A100,A1)=1,A1,"") and drag down
wher col A has your values
you can always copy/ paste special /values the result to a spare column paste special values then sort

[dreicer_Jarr]

Perfect. I will want to remove the blanks, but have a macro that can "sort them out"...this will work...thanks!!