Quote:
Originally Posted by johnmerlino
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".