Delete rows based on duplicate values form other rows

[zazybang]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]job[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Worker[/TD]
[TD]May 12[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Firemen[/TD]
[TD]May 13[/TD]
[/TR]
</tbody>[/TABLE]
The above data is from a LINKED response form. Is it possible to have row 1 deleted due to row 2 having the same name?

 

[shift-del]

Hi

It sounds like if the question is related to this question:-
https://www.mrexcel.com/forum/excel-questions/1055426-reverse-excel.html