Solved I am using excel and I have 2 columns of figures 79 00115 7

June 11, 2013 at 18:17:19
Specs: Windows XP
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


See More: I am using excel and I have 2 columns of figures 79 00115 7

Report •


#1
June 11, 2013 at 18:38:22
✔ Best Answer
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.


Report •
Related Solutions


Ask Question