I have a column of company names that are duplicated that I need to identify by grouping them together with unique ID's. For example: I have row 1, 2 & 3 with ACME, row 4 with Smiths & Co and row 5, 6, 7 & 8 with Jones & Son. In the column next to these names I need a unique ID placed for each unique company so row 1, 2 & 3 in the 2nd column will have 1, 1, 1 - row 4 column 2 will have 2 - row 5, 6, 7, & 8 column 2 will have 3, 3, 3, 3 etc...
Any ideas?
Bookmarks