Removing Duplicates

[blackgolf]

Hi Guys

I need to remove duplicates in Column B, but keeping the FIRST and LAST occurrence.
Example
All the duplicates in RED must be deleted, the complete row.

john
john
john
john
frank
frank
peter
peter
peter
peter
peter

If there are only 2 duplicates, like frank, then nothing must be deleted.
Many thanks for the help.
Chris

 

[blackgolf]

OK got you.
Thanks a lot it is working now. So one learn every day.
Have a great day.

 

[steve the fish]

Don't forget to copy paste values before you do any deleting/ sorting or it wont work!

 

[blackgolf]

Will do, thanks Steve