hi der

I have 2 columns containing names/codes. I want to create a 3rd column
containing the names/codes which are not present in both columns.
Or i want to create 2 columns. Column C containing the names/codes which are
not in column A and Column D containing the names/codes which are not in
column B.
Can anyone help with formula or tell which function would suite best or if
it is possible. I have no idea how to use macros so i want to stay away from
this.
Thanx