retrieve numbers excluding the repeticions

P

pmarques

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 :)
 
S

swatsp0p

pmarques said:
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 :)
Click to expand...

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: Data>Filter>Advanced 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
 
M

Max

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
 
Top