Compare columns

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

How do I determine whether the data in COL A exists COL B?
How do I determine whether the data in COL A does NOT exist in COL B?
 
You could use conditional formatting:

1) Click on cell A1
2) Click format, conditional formatting
3) Change Condition 1 to 'formula is'
4) Enter '=COUNTIF(B:B,A1)>0' into the formula space (without quotes)
5) Click the [Format] button and the 'Patterns' tab
6) Choose a colour
7) Click [OK]
8) Click the format painter
9) Click the 'A' at the top of column A

Everything that is highlighted in the colour of your choice is listed in
column B. Everything not coloured is not in column B:

If you need further help, try http://www.contextures.com/tiptech.html under
headings 'conditional formatting'
 
You must log in or register to reply here.

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

Find largest value in column with 2 criteria 1
Nested IF conditions 3
Counting unique values in multiple columns 4
Excel 2007 Like or Contains Expression 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Put parts of cell into separate columns 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Eliminating cells with non-matching characters 1

Back
Top