Automatically elliminate duplicates within a spreadsheet?

[frenchbox]

Hi everyone,

Operating with huge lists of domain names and other similar statistical
stuff I desperately need to find a solution in order to eliminate
similar entries within a table.

Any ideas as to a possible remedy (formula or function)?

Thanx in advance

 

[Duke Carey]

You could load it into Access or MSDE and use a simple query to extract
DISTINCT rows. Can be much, MUCH easier than fiddling with it in Excel

 

[Gord Dibben]

Data>Filter>Advanced Filter.

Check "unique records only" and "copy to another location".

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP

 

[frenchbox]

Thanx a lot - it worked just fine