| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out single values (keeping only repeating data)
If your data is in column A then in column B you can use this formula:
=IF(COUNTIF(A$2:A2, A2)1, A2, "") it will give you the nombers those are more than once. "anthonyd" wrote: Is there a way to filter out all the values in a column that only appear once, leaving just items that appear 2+ times? I know there's a way to get rid of duplicates, but I haven't been able to find a feature that would do the opposite. Thank you for your insight! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping a running total in a single cell | Excel Worksheet Functions | |||
| FILTERING SINGLE CHAR | Excel Discussion (Misc queries) | |||
| excluding repeating values | Excel Discussion (Misc queries) | |||
| Fixing a single cell reference keeping others dynamic | Excel Worksheet Functions | |||
Hybrid Mode
