AnsweredAssumed Answered

Duplicate Values

Question asked by brianj77 on May 13, 2016
Latest reply on Jun 16, 2016 by brianj77

Hi

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.

 

Brian

Outcomes