Please can someone help me solve this.


I have huge data of above 20,000 rows and about 10 columns. Column A have names of items. Column B has functions associated to A. I want to keep only rows of items that have mutiple functions. A sample of my data attached

Data.xlsx

I want to delete all Rows of Diana Grace and Jacob which have just on function (be it Clerk or Manager) and keep all rows of James, Peter and George who have two functions (Manager and Clerk). I will be sorting the data in accordance to column A (names). I hope someone can help me. Thanks in advance.