View Single Post
  #1   Report Post  
johnmerlino johnmerlino is offline
Junior Member
 
Posts: 2
Default 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.