Log In
Register
Home
Deleting a row with duplicate values
Tom Borg
Active Member
Members
Forum Posts: 5
Member Since:
September 12, 2018
September 12, 2018
Offline1
September 12, 2018 - 3:07 am
Suppose I have an Excel sheet that looks like this:
| ADVISOR # | ADVISOR NAME | CUSTOMER |
| 123 | Steve | Rose B |
| 123 | Steve | Anne W |
| 123 | Steve | Ralph M |
| 456 | Steve | Charles R |
| 456 | Steve | Adelaide A |
| 456 | Steve | Julian R |
| 456 | Steve | Cathy D |
| 456 | Stephen | Isabella B |
| 789 | Clay | Stephen C |
| 789 | Clay | Beth B |
| 1011 | Robert | Carolyn M |
| 1011 | Robert | Sharon P |
| 1011 | Robert | Jill H |
| 1011 | Robert | Marissa C |
| 1011 | Robert | Sharon P |
| 1011 | Robert | Staci H |
| 1011 | Robert | Elizabeth H |
| 1213 | Daniel | Gia B |
| 1415 | Richard | Debra S |
| 1415 | Richard | Maureen D |
| 1617 | Timothy | Beverly K |
| 1617 | Timothy | Charles R |
| 1819 | Bryan | Deborah M |
| 1819 | Bryan | Jeremy R |
What I want to do is have a formula or macro that will look at the Advisor # in column A, then look at the customer name in column C. If the name in column C is a duplicate (in red in my example), AND the Advisor # is the same for that customer, then delete the row for one of the duplicates (the second entry would be preferred, as it occurred later in time – there are several other columns, including a date column). If the advisor number is DIFFERENT for a duplicate customer, then do nothing.
So in my example above, the row with the 2nd Sharon P would be deleted, but the row with the 2nd Charles R would be ignored. My original data set will have 20,000 rows or more.
Can you help?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Richard West, Dana Friedt, Kathleen Hayter, Brenda Richards, Shawn Barwick, Nada Perovic
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Forum Stats:
Groups: 3
Forums: 24
Topics: 6218
Posts: 27265
Member Stats:
Guest Posters: 49
Members: 31901
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —