This questions seems to have been asked a lot in some fashion. However I can't seem to find an answer to my specific variation on the question.
There are many posts and discussions on finding and identifying duplicate values: pretty straightforward with lots of options and solutions
Finding the records with duplicate values is OK but managing them seems to be something different. I can filter the duplicate values but want to delete the 'spare' copies retaining 1 copy of the record. Currently all the solutions seem to imply that I want to delete all records.
If have 3 copies of a record I want to delete 2 but still keep one. Am I being dumb and missing something? (very possible and, indeed, likely).
I cannot find a solution to this. Has anyone got ideas about how to solve this?
Thanks in advance for taking the time to read and respond.