Need help of formula to find repeats of count of duplicates B,C and D column

[jacktc]

Dear experts

I am still seeking help to find solution for find repeats of count ,i have set of data which need to validate by group of duplicates.
for e.g Deform code in A column 1030651859 has combination of B,C and D value and same value of B,C,D repeats in another deform i want count for fist B,C and D is result 1 and for second B,C and D combination 2

second criteria Deform code 1037202889 repeats twice, B,C and D with double line, and same double line repeats under some other deform code.

find the column G:G is my expected result.i want formula for G column if you have better idea to find best way help me

regards
jack

 

[p45cal]

I don't get exactly the same results as you, perhaps it's because I've misunderstood, but try in row 2:

=SUMPRODUCT(($B$2:$B2=$B2)*($C$2:$C2=$C2)*($D$2:$D2=$D2))

and copy down.

 

[jacktc]

yea bit complicated, does it work if concatenate(B,C&D) find unique through E column i just want first Repeat unique , find the sheets of Scope1,2,3,....9 i took only first unique value

 

[p45cal]

i just want first Repeat unique

Just add =2 to the end of the formula and this will show TRUE for the first repeat, FALSE for everything else.:

=SUMPRODUCT(($B$2:$B34=$B34)*($C$2:$C34=$C34)*($D$2:$D34=$D34))=2