Filtering out single values (keeping duplicates)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi anthonyd

You can insert this formula in B2 with your first data cell in A2 and copy down
I use the data range A1:A24 in this example (A1 = the header)

=IF(COUNTIF($A$1:$A$24,A2)=1,"Unique",IF(COUNTIF($A$1:$A$24,A2)=0,"Empty","­Duplicate("& COUNTIF($A$1:A2,A2)&")"))

DataRefiner can insert the formulas for you if you want
http://www.rondebruin.nl/datarefiner.htm
 
Please refrain from multiposting. One post is enough and if you need to post
to more than one group cross post instead, that makes sure people don't
waste their time helping out when a question has been answered already
 
Back
Top