Formula for finding identical numbers in rows of numbers

[bansche123]

Dear Forum Users,

I would like to kindly ask for help regarding creating a formula that would find identical numbers in the rows starting from G3:J3 to G17:J17, and then representing those identical numbers as values of “1” in the rows created from M3:P3 to M17:P17. When number aren’t identical value “0” shall be put by the formula. I created a file where I did by hand what I would like the formula to do. The yellow highlighting is just so you better see what I mean, it is not necessary to be included.

Obviously there may be more than just two numbers identical, so the formula shall scan the whole row and not just look for “pairs” of numbers (as shown in the file) but also be able to identify for instance three or four identical numbers in a row.

Thank you very much in advance

[BMV]

Please Login or Register  to view this content.

[AliGW]

Obviously there may be more than just two numbers identical, so the formula shall scan the whole row and not just look for “pairs” of numbers (as shown in the file) but also be able to identify for instance three or four identical numbers in a row.

Not obvious at all from the example given, which does not show this! Please provide sample data that shows examples of what you mean by this.