MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find unmatched

Posted by Adam K. on February 17, 2000 9:01 AM

I need to do the exact thing that Find Unmatched query in Microsoft Access does. But i need to do it in excel.
I have to compare two columns and have it list the discrepancies.

Any help . thanks

Posted by Mark on February 17, 2000 12:22 PM


Ivan Moala's response to "compare column data - Gary 2/14/00" below, should get you started. Cells that are not grayed in col A do not appear in col B. Now just clear or whatever rather than color, and you will have a list of the differences.


Posted by Celia on February 17, 2000 4:00 PM


If you prefer to do this with a worksheet formula instead of a macro, the following should do it.

If your two lists are in column A (say, A1:A10) and in column B, the following array formula will give the entries in column B that do not appear in column A.


You might find it helpful to look at :-