View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default finding the common names between columns

good day All

I have recentlyexctracted a list of users names from AD to compare it
to another list that got extracted from SAP.
now I have a list of users that might not be on the next list.
How I have it placed is like so..
One coulumn has a list of first names and the other the last name..
Now since I have two sets of name I have four coulmns with fisrt names
and last names..
what I would like to do is find out the names that appear in the first
two coulumns that does not appear in the next two coulmns on another
column or sheet..
the basic idea is just to find out the ones that are not common..
I have been reading around in the sites and and I have not really
found out what I am loking for.
so this is the run down of what I am doing.. I am not that good in
excel so would someone please help me on this

Thank You in advance to all..
Seelan