Remove duplicate names from 2 colums / multiple rows

[quikgun15]

Hi,

Hoping someone can assist. I've attached my spreadsheet.

I have 3 colums with multiple rows for one user.

Column A is my user
Column B is a group they're under
Column C is groups that they need to be added to


I need two things:

#1: There are duplicates within columns B & C (over multiple rows) - which i would like to get rid of.

#2: If the group exist in Column B for the user, i need it to be removed from Column C or somehow highlighted or easily pointed out so i can delete manually if i need to
for e.g. in the chart below... WB35 is in Column B and Column C.... what i need is for it to be removed from Column C

A B C
USER Group Additional Groups
a WB47 WB12,WB31,WB35
a WB35 WB02,WB07
a WB08 WB01,WB11,WB09



Any help is appreciated.