detect in each group the corresponding.

[jorel]

detect in each group the corresponding numbers
we have 10 groups of 5 numbers and the macro will find if there is repetition in the same position
and add the quantity, in the two groups of the two colors,
https://www.excelforum.com/attachmen...1&d=1568057815

[jomaor1]

It has to be a Macro?

Because you could just do the following:

=COUNTIFS($Q5:$BW5;"x";$Q$3:$BW$3;BY$3)

put it in cell "BY6"

If you want it in a Macro, just tell the Macro to write it in BY6, and then copy to CC6 (or copy down too)