I have a list of repetitive words in col d that I would like to have associated with a constant numeral in col c.
example
col c col d
1 jones
1 jones
1 jones
2 smith
2 smith
The number of occurance for each similar text, however is variable. I may have 5 or 25 rows of the same word.
Currently, I add the numerals in col c manually, how can I automate this task? I've attempted using vlookup, but my since I am not using col a, I am not sure how to run it. thanks
example
col c col d
1 jones
1 jones
1 jones
2 smith
2 smith
The number of occurance for each similar text, however is variable. I may have 5 or 25 rows of the same word.
Currently, I add the numerals in col c manually, how can I automate this task? I've attempted using vlookup, but my since I am not using col a, I am not sure how to run it. thanks