Feb 08 2021 03:29 AM
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?
Feb 08 2021 05:52 AM
You may add helper column with formula like
=COUNTIF(nameRange, currentName)> 3
filter and remove rows with TRUE