Checking if a value of a cell is duplicated more than 5 times in a column
 

Hey all,

Is there a formula I can use where if a value of a cell is repeated more than 5 times in a column, then remove all instances of five or more duplicates in that column. There could be multiple duplicates of 5 or more.

Thanks for any response.

If your list is in column A, then B1 should have:

=IF(COUNTIF(A:A,A1)=5,"More than 5","Less than 5")

Copy that formula all the way down, then do a FILTER of "Less than 5".