I have a list of 20 names in cells A1 through A20. I want to be sure no names are repeated -- if a name occurs twice in the list, that player is being weighted double which is a problem.
Is there an easy macro to see if any of the names in that range are identical (to give an error message)?