pmarques Wrote:
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 :)

Use "Advanced Filter". Make sure your data range has a column header
(e.g. "List"). Highlight the range of data (including the header) and
choose: DataFilterAdvanced Filter...
Select Copy to another location, enter the destination you would like
to display the results in the Copy to: range, check the "Unique records
only" box and click OK

HTH

Bruce


--
swatsp0p


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