Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out single values (keeping only repeating data)
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out single values (keeping only repeating data)
See your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "anthonyd" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out single values (keeping only repeating data)
Use a help column and a formula
=COUNTIF($A$3:$A$200,A2)<1 then filter on TRUE You can do this in one fell swoop using advanced filter, leaving criteria header blank and the same formula =COUNTIF($A$3:$A$200,A3)<1 -- Regards, Peo Sjoblom "anthonyd" wrote in message ... 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! |
#4
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 |