Duplicate Entry Search

J

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?
 
M

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.
 
Top