I have a single worksheet with 2 columns with overlapping data, meaning that there is some duplicate content between the 2 columns. Ideally, what I'd like is to magically create 2 new columns - 1 with a consolidated list of data present in column a and not in column b, and the other with the reverse.

What's the easiest way to accomplish that or even the correct search terms to find the answer myself?


thanks,
will