I have an ongoing file in which every quarter I import a list of about 20 different names and I wish to have each different name be associated to a numerial in the next column.
For example: in col B I have the name John repeated 15 times, Sally 10x's, and Joe 3x's. I wish to have the number 1 match John, 2 match Sally, 3 Joe, and so on.
Currently, when I have my final list for the period, I sort the names list, then associate the predefined number to it's respective name. Is there a faster way? thanks
For example: in col B I have the name John repeated 15 times, Sally 10x's, and Joe 3x's. I wish to have the number 1 match John, 2 match Sally, 3 Joe, and so on.
Currently, when I have my final list for the period, I sort the names list, then associate the predefined number to it's respective name. Is there a faster way? thanks