What is the easiest way to count cells with the same value, across columns?
<tbody>
</tbody>
The first 4 columns have names as above, and column F has the number of non-duplicates - I hope I'm explaining it okay!
Thanks for the help!
A | B | C | D | E | F | G |
Jack | Jill | John | Jane | 4 | ||
Jack | Jack | John | John | 2 | ||
Jill | Jill | Jill | 1 | |||
John | Jack | Jack | Jane | 3 | ||
<tbody>
</tbody>
The first 4 columns have names as above, and column F has the number of non-duplicates - I hope I'm explaining it okay!
Thanks for the help!