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