Comparing Two Columns

C

Candy

I have to compare a few columns. I have one column that contains all of our
customers, the other is a list of customers who subscribe to a particular
service. I need to find out from the master list, which customers are not
subscribing. Can you help? I thought I could use a pivot table but I'm not
sure. Any suggestions would be great.

Thanks!
 
P

pinmaster

Hi,

You could use Conditional Formatting to highlight the costumers that do
subscribe. Start by selecting the master list then go to Format/Conditional
Formatting, next select Formula from the drop down menu and use:

=COUNTIF($B$1:$B$100,A1)>0
where $B$1:$B$100 is the list of subcribers and A1 is the first cell in the
master list!

click of the Format button and format as desired!

HTH
Jean-Guy
 
C

Candy

Thank you, I'm going to give it a try. How would the formula change if I
wanted to get a list of those mismatched subscribers?
 
P

pinmaster

Hi,

=COUNTIF($B$1:$B$100,A1)=0
cells highlited if no match is found

=COUNTIF($B$1:$B$100,A1)>0
cells highlited if a match is found

Hope this helps!
Jean-Guy
 
Top