Is there a formula to let me count if there are duplicates showing up in a row?
If I have 3 to 6 columns of individual numbers, I'd like to know if any numbers are duplicated in any particular row? To keep this simple, the best way to think of it is lottery numbers: If I have rows with 7-7-5; then 4-5-2 below that; then 1-5-7; then 2-2-5; then 1-0-9; then 1-1-3; then 1-0-1; then 5-4-2. You can see that the first, fourth, sixth and seventh row had duplicates.
Is there a formula that would calculate that for me?