Check text in range of cells
To check for all unique:
=SUMPRODUCT(--COUNTIF(D4:I16,D4:I16))=COUNTA(D4:I16)
To see how many times the name in A2 appears in range:
=A2&" "&COUNTIF(D4:I16,A2)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"tommcbrny" wrote:
I have names in a range of cells from D 4 - I 16. I would like to do two
things:
1) Check that each name occurs only one time in each column, D - I, and
confirm with a True / False in another cell.
2) Check how many times a name appears in the entire range and print name
with the number of times it appears to another cell.
Is there a way to do these?
Thanks,
Tom
|