extracting unique #'s from a list

[matmich]

my last post was dealing with sumif function and you guys got me on th
right track. Now I have column with some duplicate #'s. How can
extract the unique numbers into a different column??

A1 B1
1 1
1 2
2 3
3 4
4 5
4 6
5
6
2

 

[Frank Kabel]

Hi
one way:
use 'Data - Filter - Advanced Filter' and check 'Unique values'.
Also have a look at:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[AlfD]

Hi!

Have a look at Data >Filter >Advanced Filter
It's pretty intuitive, but come back if you need more detail.

Al