Deleting Duplicate Entries

  • Thread starter Thread starter tgentry0419
  • Start date Start date
T

tgentry0419

I have a huge spreadsheet with over 7500 rows which has
been given to me. A large number of the entries are
duplicated many times within the sheet. Is there a way to
run a macro or a worksheet function which will
automatically find and erase the duplicate entries based
on one unique column that I can use?
 
Data>AdvancedFilter: check "Copy to another location" *AND* "Unique records
only". Also specify the range of data you want filtered (ListRange) and
where you want the new list to go (CopyTo). Criteria can be left blank.
This should generate a "clean" list of unique records without disrupting the
original data.

Note that a "unique record" is the combination of all columns included in
your List Range. You may need to experiment and exclude some columns to get
what you want (it depends entirely on your data).
--

HTH,

George Nicholson

Remove 'Junk' from return address.
 
Back
Top