| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
Quote:
=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".
__________________
Asobi Wa Owari Da |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i have info many times duplicated and need to make a list of just. | Excel Worksheet Functions | |||
| How to remove duplicated data repeated in a column and keep just o | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking if information in a cell is within a column | Excel Worksheet Functions | |||
| Why do I get a duplicated column in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
