Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I filter two columns of names to see What names are the same?

I have two lists of names (one with 2,000+ names and one with 300+ names) I want make a column that shows the names that are not in both columns and the names that are. Is there an automated way of doing this?


Basically, I have 2,000 friends on facebook and only 300 of them like my business page. I want to know which friends to market too and which friends to stop annoying 😝 Any help would be greatly appreciated!

MacBook Pro, Mac OS X (10.6.7), 8 gb ram

Posted on Jul 7, 2011 4:26 PM

Reply
Question marked as Best reply

Posted on Jul 7, 2011 5:39 PM

Caleb,


You may use COUNTIF to see what values are in both columns.


In this example I used the expression: =COUNTIF(B,A)


User uploaded file

Regards,


Jerry

2 replies

How do I filter two columns of names to see What names are the same?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.