Macro to compare 2 columns cell contents and add 'Yes' flag for record

Hi All - I have used this forum many times but this is the first time I am posted a question. I am looking for a solution that will help flag records in a spreadsheet that meet criteria. I have a very large spreadsheet of data from an HRIS system. It has over 50,000 rows. I have done a visual check, but hope to find a programatic way to ensure I caught everything. I do not have access to the HRIS system, I have to work with the export.
We discovered that some teams in the company have different codes assigned to them. We need to flag all records where the collective team name is the same but the team code changes.

In the example this file is sorted on Column C and a secondary sort on column D. This groups the team names together for visual checking.
Column C contains the 'TeamName' and Column D contains the 'TeamCode'. I need to flag records where the same name is entered in Column D in above and below cells, but the TeamCode assigned to that name has changed if compared to above or below cells. I need to flag all records that meet this criteria so we can update them correctly in the system.
If you look at 'Problem Management', it has multiple team codes assigned to it. In this case, I have flagged all records containing 'Problem Management' with 'Yes' in the last column. 'Mailing Services' has same code assigned to it so we do not need to flag this.

I attached a spreadsheet with sample information. Please let me know if I have left critical information out or if there is a solution using a different tool.

I have attempted to solve by isolating the columns and selecting remove duplicates. Then attempted a v-lookup. This did not provide the correct outcome. I have also tried creating a pivot table and looking for cases where a TeamName has more than 1 TeamCode. I could not figure out how to get it to filter on that criteria. I think an VBA macro is needed but I am not experienced writing code.

Thank you!

Example described above.

picture-forum.jpg
forum example.xlsx

Try this code -

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

If you want the sort action to be included in the code, it can be done as well.
Also, should TeamCode-Blank be highlighted as well?

Thats what i asked you in the bold section below my code. Should it consider the "Teamcode-blank" cells also and mark them Yes?

So even if column C matches for the rows (for e.g. 12 to 14) and column D for these has the same text (no numbers), should they be flagged?