Thread: Removing rows based unique values

Hi

I have some example data attached that has about 16,000 rows in size the real data maybe upto 100,000 rows.

Is there a way of removing rows based on the unique values of column "B" i've tried using delete row functions but this takes 3+mins to run for the 16,000 test rows.

Is there logic way of doing this super quick?

Any help would be good

Thanks
David

Is there any way of doing this?