compare 2 sets of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Shannon Schulz said:
I want excel to compare two columns of data (in 2 worksheets) and tell me
Click to expand...
if a value in column A appears anywhere in column B
 
Back
Top