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)?
Is there an easy macro to see if any of the names in that range are identical (to give an error message)?