View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Automatically elliminate duplicates within a spreadsheet?

DataFilterAdvanced 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



On Thu, 1 Dec 2005 12:44:43 -0600, frenchbox
wrote:


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 ;)