Clearing data in a row when rows start to duplicate

[S Himmelrich]

The example belowis the result I'm looking for:

SOURCE DATA:

A B C
D E
SCOTT 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5

END RESULT:
SCOTT 12 ABC 2.00 5.5
SCOTT 12 ABC
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC
JILL 123 ABC
JILL 123 ABC
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5

Basically evaluate column A, B, C, D, E, when the second row repeats
then remove values in column D, E (or replace with 0.00.

 

[JMay]

In Cell D17 enter (where your first Blank cell yakes place) - Row 3 refers to
your original 2nd row of data (assuming a header row in row1)

=IF($A3&$D3&$E3=$A2&$D2&$E2,"",D3)

Copy down and to right as needed.

HTH