I have two columns with number a & b, I would like to find identical values in both columns to show what doesn't match with column a. I am in excel. Thanks

There are lots of ways to accomplish your goal. One such way is... With your values in A1:B8, put this in C1 and drag it down to C8. It will tell you which Column A values match a Column B value and which ones don't.

=IF(ISNA(MATCH(A1,$B$1:$B$8,0)),"No Match For "&A1,"There's A Match For "&A1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll