Removing rows based unique values

[davidparkes]

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

[davidparkes]

Is there any way of doing this?