Duplicate Entry Search

[John]

I have a very large database I'm working with, and I need
to find, count, and eventually eliminate all of the
duplicate entries. Any ideas?

 

[pfsardella]

Chip Pearson has formulas for dealing with duplicate entries.

http://www.cpearson.com/excel/duplicat.htm

HTH
Paul

 

[Myrna Larson]

If by duplicate you mean that all columns are identical, just select a cell in your list, then
Data, Filter, Advanced, and select the Unique records box. Leave the other entries blank. Copy
to another location or filter in-place, as desired.