Remove duplicates for Tier 3 category

Data
Tier Category Name
Tier 1 Tom
Tier 1 Tom
Tier 1 Harry
Tier 1 Rafa
Tier 1 Daniel
Tier 2 Tom
Tier 2 Harry
Tier 2 Harry
Tier 2 CAN ATALAY
Tier 2 HANN-WEN SHEU
Tier 3 Oktar
Tier 3 Miria
Tier 3 Harry
Tier 3 CAN ATALAY
Tier 3 Tom
Tier 3 Rafa
Tier 3 Oktar

Required Output
Tier Category Name
Tier 1 Tom
Tier 1 Tom
Tier 1 Harry
Tier 1 Rafa
Tier 1 Daniel
Tier 2 Tom
Tier 2 Harry
Tier 2 Harry
Tier 2 CAN ATALAY
Tier 2 HANN-WEN SHEU
Tier 3 Oktar
Tier 3 Miria
Tier 3 Oktar

For simplification just using 2 columns from the whole table, column one has Tier category and Column 2 has corresponding names. Trying to remove duplicates From the table for Tier C, for the names which are present in Tier 1 or Tier 2.

Tier 1,Tier 2 , Tier 3 can have duplicates. But a name present in Tier 2 and Tier 1 should not repeat in Tier 3.

Trying to automate this when ever new data get pasted in this table. Automatically it should remove Tier 1 and Tier 2 names which repeated for only Tier 3 category and return the distinct names for Tier 3. I tried the following. Need to complete the formula.

IF(COUNTIFS($B$2:B2,B2,$A$2:A2,"Tier A")>=1,"Keep","Remove")
IF(COUNTIFS($B$2:B100,B100,$A$2:A100,"Tier B")>=1,"Keep","Remove")

Tier 1 has Tom and Tier 2 has Harry if you notice as Tier 1 and Tier 2 can have duplicate names/rows i.e., no need to remove the rows we can keep the exact for tier 1 and 2. But specifically for tier C, I need to consider only unique names it can also have duplicate names present in tier c itself that's why Tier 3 has Oktar, but cannot have names which are already occurred in Tier 1 or 2 hence all other names removed. Hope this helps.

I am not sure if my approach was correct. I was intending to check the names in Tier 1 and Tier 2 from top to bottom and compare with Tier 3 names, where Tier 3 will exclude the names which can be found in Tier 1 and 2 and return the unique names present in Tier 3

@DJ: nice. I got the first part but struggled with the Tier 3 bit. Only got as far as isolating Miria

You're welcome.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.