Duplicate Entry Search

  • Thread starter Thread starter John
  • Start date Start date
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?
 
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.
 
Back
Top