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.
|