I'm trying to count how many items are diffent and I get an unexpected number in some of them. I attached a test file, but here is an image also to explain what I want:
Have a look at "rc2a" in yellow. I'm trying to count how many "broker" (in green) are different for "rc2a" (yellow).
I understand the "3" results (a blank cell, "broker2" and "broker3"), but I can't figure out why sometimes excel says "2" as a valid solution.
Thanks a lot,