Hello:
I have a list with duplicates and unique names. How can I mark each duplicate and unique name with "1"
For example:
John James 1
John James
Peter Floyd 1
Mike Sutton 1
Mike Sutton
My goal is get total head count that should not include duplicates.
Thanks for your help.
Sean