Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Duplicates

Best of Excel

Delete Duplicates

by  gizmo1973  Posted    (Edited  )
A quick one this as the question comes up time and again.

Sort your sheet by the numbers you are trying to find duplicates on (in this instance we shall call it column A)
Then in a spare column type this formula

=if(A1=A2,1,0)
Then switch on auto filter and filter by 1 on your column with the equation
Then delete these 1s
This should leave you with a set of de-duped refs.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top