Comparing Two Columns

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

Guest

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!
 
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
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Combine Vlookup and If? 1
Compare two worksheets and identify common entries 3
Count unique values 5
Functions 1
Function 7
compare two columns and pull out differences 1
Comparing two lists with one being inaccurate 2

Back
Top