I have a large list of data.
There is a column that contains a set of numbers that appear twice.
I wanted to give the first occurence of the number a 1 and the second occurence of the number a 2 and then I could easily sort the data and delete all the second occurences of the name by deleting anything with a 2 value.

For example

Mary Smith 1
John Smith 1
Cindy Apple 2
Margaret Apple 2
Bob Hope 3
Mike Hope 3

I'd like to create a row that would identify Mary Cindy and Bob with a 1 and John Margaret and Mike with a 2

Thanks
L