Hi everyone,

I had a question about comparing columns....is it possible to compare
columns to each other. So, for example...

Column1 Column2

Apple Orange
Cherry Apple
Orange Grape
Melon Melon
Grape Strawberry

I want excel to compare the two columns and list me the ones that do not
match. So the results would be Cherry and Strawberry. I'm not concern on
how the out put looks. I just have to find out what dropped off from the
first column to the second and what was added on. Any help would be
appreciated.

Thanks