compare 2 sets of data

[Shannon Schulz]

I want excel to compare two columns of data (in 2 worksheets) and tell me if a value in column A appears anywhere in column

Column A Column
123 1
226889 12
39583333 7596
40000000 3670000

I want to know that 123 appears in column a and b.
Help, please!

 

[Stephen Bye]

I would use conditional formatting.
Select column A, then use the Format > Conditional menu option.
Enter
'Formula is'
=NOT(ISNA(MATCH(A1,B:B,0)))
Then press the 'Format...' button and choose how you want the matching cells
highlighted.

I want excel to compare two columns of data (in 2 worksheets) and tell me

if a value in column A appears anywhere in column B