Filtering out single values (keeping duplicates)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anthonyd - 10 Jul 2007 22:02 GMT

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 to this Message

Ron de Bruin - 10 Jul 2007 22:10 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> 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 to this Message

Peo Sjoblom - 10 Jul 2007 22:27 GMT

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

Signature

Regards,

Peo Sjoblom

Reply to this Message

Rate this thread: