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
"S Himmelrich" wrote:
> 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.
>
>
|
Similar Threads
