I need to find and remove all instances of duplicate values including the original, if any of the duplicates are status 1. I can't just find and delete all status 1 entries, because any names repeated that are at status 2 would need to be deleted as well. Would it be easier to search all status 1's, take the relative reference name and delete all instances of that? or is there a simpler way?
For example:
Column A Column B
<tbody>
</tbody>
Should become:
<tbody>
</tbody>
For example:
Column A Column B
Status | Name |
2 | A |
2 | B |
1 | B |
2 | C |
2 | C |
1 | D |
2 | D |
<tbody>
</tbody>
Should become:
Status | Name |
2 | A |
2 | C |
2 | C |
<tbody>
</tbody>