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