Hi Guys,
I'm still a learner, and struggling to get my head round a seemingly simple idea!
I have a workbook with which I am using to counteract multiples within a system by matching them with multiple criteria. I've now reached a stumbling block, I have a set of data of which I have identified as duplicates but i cannot for the life of me work out how to select just one of each duplicate so they can be removed from the system!
Kind regards and thanks in advance!
Mia
Welcome to the forum.
I don't understand what you are showing us, sorry.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oh Gosh, Sorry! Thankyou for your prompt reply!
So the worksheet i've attached has a column with postcodes in, and these are in sets of 2 (1 being a duplicate I need to get rid of).
The problem i'm finding is that if I try to select duplicates it finds them all, but I just need to select one of each of these pairs and delete the row associated with it.
## i've updated the SS, so it shows an example of what i need to happen (conditional formatting would be amazing so i can just filter the duplicates out but keep their legacy), the red ones being the ones i want coloured/gone. Is this possible?
I hope that makes sense!
Mia
Last edited by Miasav90; 09-23-2021 at 06:57 AM.
You could use this formula in L1:
=IF(COUNTIF(F$1:F1,F1)=1,"keep","delete")
Copy down to the bottom of your data, the you can use Auto filter to select "delete" and delete them in one operation.
Hope this helps.
Pete
You could use Pete's formula and then filter on column L (keep only).
Oh my,
you guys are amazingThankyou so much!
Mia
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Power query
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks