ExcelBanter - compare two columns in Excell 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - compare two columns in Excell 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/201188-compare-two-columns-excell-2007-a.html)

vhagerty

compare two columns in Excell 2007?

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

compare two columns in Excell 2007?

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.

--
Biff
Microsoft Excel MVP

"vhagerty" wrote in message
...
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.

All times are GMT +1. The time now is 09:14 PM.