Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
Columns | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Finding a match in several columns | Excel Worksheet Functions |