Delete entire Rows if Column value is unique OR Duplicate is less than three

I have a worksheet where data is in Range Column A:U.

Controlling Column for data evaluation is in Column B.

I want to remove entire rows if a) cell value in Column B is UNIQUE, or b) there are duplicates but such duplicates are less than two value only

Conversely speaking, I want to RETAIN / KEEP all ROWs, if cell value in each row in Column B has duplicates >=3

I read this thread (# 4) http://www.excelforum.com/excel-prog...uplicates.html

Please Login or Register  to view this content.

This macro perfectly does the job, but keeps duplicates (even two) and i need to keep only those rows where duplicates in Column B are >=3.


Thanks

Try this:

Please Login or Register  to view this content.

Best,
berlan

WOW, That worked like a Charm. Thanks