I Am trying to get a Match Count on Rows,
I am using a Player card a which has 7 name on that
and I want to find a formula where if it find 2 name in 1 row it will make a number 1, if 3 name in 1 row list the number 2 next to the name and do this for all the rows.
I have used an example...