One way is to use the unique filter in Advanced Filter

Assume data is in col A
Insert a new header cell A1 (type a label), then select the column
Click Data Filter Advanced Filter
Check the boxes for "Copy to another location" & "Unique records only"
In the "Copy to:" box, enter, say: B1
Click OK

The list of uniques will be extracted in col B
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"pmarques" wrote in
message ...

I Have one columm with numbers (with one or several occurrences)
34567
34567
54311
12345
54311
33321
..

and i want in other columm
(only one occurrence of each number, preferably without blank spaces)

34567
54311
12345
33321
...

How can this be done???
Thanks :)


--
pmarques
------------------------------------------------------------------------
pmarques's Profile:
http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=467841