Forum Discussion
Find mismatches
I want a way to flag or highlight a cell in Column B if the content does not exactly match the content on the same row in Column A. My spreadsheet has hundreds of rows of data, and just a few mismatc...
There are few of a ways to do that. By CF
=$B2<>$A2To get Mismatch values list, you may try-
=FILTER(B2:B10,A2:A10<>B2:B10)
=FILTER(B2:B10,COUNTIFS(A2:A10,B2:B10)=0)