compare two columns in Excell 2007?

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.
 
T

T. Valko

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.
 

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

Using Regular expressions in Excell 2007 1
Reseting the Standard colors in excell 2007 1
sum by dates-Excell 2003 1
opening 2007 files in 2003 2
value in cell B < value in cell A conditional format 3
hiding columns in Excell error message 2
Make cells in Excell case sensitive 3
Working Excel 2007 pivot table, want just text to show on the pivo 2

Top