I have two columns of numbers, column A and column B. Column A is where a numbered tag is entered when it leaves and Column B is where the numbered tag is entered when it returns. There are spaces in both of these columns. I am having trouble finding a proper formula or way to display in two additional columns tag numbers that were sent but not returned, and tags that were returned but not sent, essentially numbers that don't appear on both columns.
Excel – Comparing two columns in excel to find non-duplicates
microsoft-excel-2007
Best Answer
Look into
MATCH()
- it will displayN/A
for not found,IF(ISNA(...),...)
will help for those if you wish to display something else. Example sheet below.-- Untitled.csv --