Compare 2 columns in a spreadsheet

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I have a spreadsheet with 2 columns and i want to compare the data in
the two columns

I have been using the following formula, but it is not working... any
help is appreciated

=ISNA(MATCH(A2,$J$2:$J$359,FALSE))


Thanks

Samir
 
Looks like you're trying to see whether col A's items are found in col J
Perhaps try in say, K2:
=IF(COUNTIF($J$2:$J$359,A2)=0,"No","Yes")
Copy K2 down as many rows as there are items in col A
Col K will return "No" / "Yes" for item(s) in col A not found / found in col
J
 
Back
Top