i looked through the solved threads already and found similar requests but not entirely what I am seeking.
compare 2 columns A and B and report in C items from A that are missing in B.
A is like a control column containing master data. items can be numbers or words or alphanumeric data.
note: it is possible that column B might have multiple listings of the same item. In that case I do no want the second item reported as missing as I saw in one solved worksheet.
example
A has the following
birds
123
fish
777
seas
115
and B has the following
123
seas
123
115
777
fish
column C would report
birds
the 2nd occurrence of 123 in B is not reported as missing because once it occurs in A it's a hit.
Hi Sweetypie,
In column C you could use:
=IF(ISNUMBER(MATCH(A1,B:B,0)),"",A1)
Fill that down as many rows as you have in column A. This will create a list of values in column A that aren't matched in column B. You can then copy column C and use pastespecial on top of itself to convert those formulas to values, then sort column C to remove the blanks.
Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks