Hi all

Pretty new to excel, and attempting to compare two columns of data to find the common values.

e.g I have the following 2 columns of data

column1 column2
a b
b c
c e
d g
e x
f y
g z

what I am trying to do is from these 2 columns, determine whthe list of

1. Common values
2. Values that appear in column 1 but not in column 2
3. Values that appear in column 2 but not in column 1

The data is provided from a database. I tired using the 'IF' function but I could not work out how to say "if the value of a column 1 cell is in the whole range column 2".

Using The help section in excel, i could only work out how to do this as the examples only compare one value against another, not against a range.

any ideas?
thanks