How to Compare Each Row in One Column for a Match in Another Column

Cornelius Wilson 0
Viewed 42

I have values in column B and C. All except 4 from column B should have a matching pair in one of the rows from column C.

I tried to use the code =FILTER(B:B, ISNA(MATCH(B:B, C:C, 0))) but that only shows me 7 matching values. Any idea why it's not matching the 75 of 79 values?

enter image description here

google-sheets
1 Answers

Use this formula

=BYROW(B1:B, LAMBDA(x, IF(x="",,IFNA(INDEX( C1:C, MATCH(x, C1:C, 0), 1),"Missing"))))

enter image description here

Find missing

=IFERROR(FILTER(B:B, ISERROR(MATCH(B:B,C:C  , FALSE))), "No match")

enter image description here

Osm0
Related