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