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!

Excel Macro to find and delete duplicate records and their originals

Status
Not open for further replies.
mookie0001

mookie0001

Technical User
Jun 14, 2002
23
US
I need to be able to write an excel macro that will be able to search a column of my choice for duplicate records. Once the macro finds a duplicate record I need it to delete all duplicates AND the original. For example, if the column has the records A, B, C, C, C, D, E, when the macro is finished the column will only have the records A, B, D, and E.
 
Sort by date Sort by votes
I forgot to mention that the version of excel is 2000.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
220
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
Duplicate yes
Replies
5
Views
159
strongm
strongm
sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
127
sal21
sal21
44MARCO
  • Locked
  • Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL 1
Replies
2
Views
236
strongm
strongm
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
188
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top