retrieve numbers excluding the repeticions
 

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

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

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

:) It works fine
Thanks a lot


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

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--