compare two columns in Excell 2007?

  • Thread starter Thread starter vhagerty
  • Start date Start date
V

vhagerty

I'm using Excell 2007 and need to figure out a way to take the cells in
column A (text) and check to see if they are in column B. If so identify
them some way in column B. Hopefully this can also be compatible with Excell
2003 also.
 
One way that is compatible between versions...

Enter this formula in column C and copy to the end of data in column B:

=IF(COUNTIF(A$1:A$15,B1),"x","")

"x" marks items in both columns.
 
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

Excel Comparing two columns 1
counting blank cells within two columns 2
comparing two columns 2
Excel 2007 comparing dates 5
Conditional Format Range of Cells 3
Numbers showing Up Centered in Cell ? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Concantenate which keeps bold of some parts. 5

Back
Top