Extract values from a range that are missing from another
I have two columns in Excel (Column A and B , going left to right), like so:
Adel Adel Adam Bob Ashley chad chad mike morris muhsin
And I'd like to get all the items from Column B that are not in Column A: i.e., Bob, Mike, Morris, Muhsin.
I know I need
VLOOKUP() , however I'm a bit lost on how to do it.
I appreciate any tips or advice.