Nobody here knows how to do this. How awesome with Excel are you?
I have two columns of numbers. I need to know what numbers are in column A that are not in column B. This seems like it would be so easy but for the life of me I can’t figure it out.
V-Look up. Kind of complicated so find a local expert to help you.
Use the vlookup function with the last argument set to ‘FALSE’. Sort column B in ascending order(this is required for the vlookup function). Then vlookup column A in column B. The values that return ‘N/A’ will be the one NOT in list B.
Example:
Assuming your list in column B is to cell B15
=vlookup(A1,B1:B15,1,False)
Vlookup is the easiest. Just make sure that if you copy the formula down you put a $ in front the row number of your range.
For example, =vlookup(A1,B$1:B$15,1,False). Otherwise your range will change with each cell you copy down and the search won’t work for the bottom cells.
Tyrius, 5280, woofy, and TriMike, thank you sincerely. You’ve made my day so much better you wouldn’t believe it. Worked like a charm.