Remove rows if they appear less than 3 times

Occasional Visitor

Hi there, So I have a spreadsheet with lots of rows and columns, in one column is 'Names'. I would like to remove rows with the same names, but only if they appear less than 3 times. Is there a rapid way of doing this? 

1 Reply


You may add helper column with formula like 

=COUNTIF(nameRange, currentName)> 3

filter and  remove rows with TRUE