How to identify if the same data in one column has the matching data from another column

Hello,
Within a spread sheet of data I have two columns of variable data. The first column has a 'codeword', (Johns Team for example). In the next column I have a list of letters which indicate which group ID they have been allocated to.

The issue is it that I need to go through the data and ensure that all those people that have put 'Johns Team' are in the same group and change them all to the same if not. The column of 'codewords' can be anything and everything.

I think this can be split into two parts. First part to identify which codewords have different groups to the other matching codewords. The second part would be to automatically change the group ID to the same as the others (or the other if there is just two).

Hope that makes sense. I do this manually but when looking through 8000 rows of data its a super time consuming process.
Look forward to the your replies.
Thanks
G

Hello G
I would try using filters to show the codename e.g. 'John's Team' and the replace feature with a wildcard (*) to replace all the ID's with the correct code for all of the filtered records. Alternatively, you could use a column of lookup formulas and copy the values into the appropriate column. You could also use VBA to loop through the column of ID's and insert the correct value. Whichever, it would perhaps be wise to create a table with your Code Names and relative ID's

Hope this helps.
DBY

DBY,
Thanks for the reply. I thought about filters but as there about 3000 different codewords this would take for ever!
The tricky part is that I have set the ID's based on other variables, so the codewords could have any ID, but i just need to ensure that all matching codewords have the same ID!
Welcome your further reply.
G

I guess you still need to go through the codewords to apply the correct ID, I don't see any way round this at the moment. What are the variables that you set each ID with, is there a consistent criteria which could be applied to the whole range of codewords?