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