Duplicate help!!

[Jarlath]

Hi,

The overall problem I have is that I need to identify codes found column H and column J that match, When they match I need to identify if the order number is different in column E. So when the number in H has a match then look in in J for a code that duplicates.


H J E Identifier
1234 Mot 11 1
1234 Service 12 0
1234 Mot 13 1
1235 Service 14 1
1235 Mot 15 0
1235 Service 16 1

I need to match the code in H, with other codes in column H. When the match is found I need to match codes in column J. If the codes match and repeat under different order numbers (E) then a Unique Identify is to be made. The final stage is Pivot off the data and exclude the 0 Identifiers.

Any help would be great.

 

[Marcelo Branco]

Maybe this (assumes data begin in row 2)

K2
=COUNTIFS(H:H,H2,J:J,J2,E:E,"<>"&E2)
copy down

Hope this helps

M.