Re-Help finding duplicates

[JDS]

Someone here a few years ago posted the formula/process to find duplicate
data so it could be sorted then deleted. Here is my situation:

Report

a b c d e
1 yellow 5 b 7
2 yellow 6 c 9
3 yellow 5 d 9
4 blue 1 w 8
5 blue 5 m 8
6 yellow 1 m 9

The process that was posted was to add a formula in column e to enter an "X"
any time data in column a was a duplicate. So the result would have placed
an "X in e2, e3, e5, and e6 - looked like this:

a b c d e
1 yellow 5 b 7
2 yellow 6 c 9 X
3 yellow 5 d 9 X
4 blue 1 w 8
5 blue 5 m 8 X
6 yellow 1 m 9 X

I could then sort on e to X only, delete those rows and remove all
duplicates. Can someone help nme with this? Thanks in advance!

JDS

 

[Frank Kabel]

Hi
in E1 enter
=IF(SUMPRODUCT(--($A$1:$A1=A1),--($B$1:$B1=B1),--($C$1:$C1=C1),--($D$1:
$D1=D1))>1,"X","")
and copy down

 

[JDS]

Thanks you.

Hi
in E1 enter
=IF(SUMPRODUCT(--($A$1:$A1=A1),--($B$1:$B1=B1),--($C$1:$C1=C1),--($D$1:
$D1=D1))>1,"X","")
and copy down