I have 2 lists of numbers. Many of them are the same, but I want to find out which are missing from list A. So they might look something like:
All I want to see is if there are numbers in list B that aren't on list A. I'm not worried about the reverse - it can appear on list A and not B and that doesn't matter. How can I easily compare the two lists? So in the above example, I want 99853 & 55887 somehow highlighted or conditionally formatted so that I can add them to list A.
I am using Excel 2013 and don't really want to use a macro as the workbook needs to be shared and this causes problems with other users.
Thanks in advance!