Removing double records

[Flash0220]

Hello,


I received an Excel sheet with the following information.

In cells A1 to A33721 are various item numbers.
Each item number is listed twice of more.

I now want each item number to be listed only once.
So if an item number is listed three times,
two numbers have to be removed.

Is there a formula to mark the numbers who have to be deleted ?

Could anyone help me with this little problem ?


Best regards,
Frits Jager

 

[royUK]

You might be able to use the asap addin using the columns and rows conditional select and choose duplicate values.
Download the free addin from http://www.asap-utilities.com

 

[Jim North]

You could use Advanced Filter and ask for unique records...

 

[eliW]

Hi Flash,
Data | Filter | AdvancedFilter
in "List range" enter your range: A1:A33721
Check on Unique records only
Copy to another location, and confirm.
This will get rid of all duplicate records.

Eli

 

[Flash0220]

Hello,


Thanks for all your help.
It works....


Best regards,
Frits Jager