Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

=name coomand in Excel 2007

Hi i have exported 3 reports from AD 2003 into Excel 2007.
In row A i have the first name and in row b i have the second name and row D and E and G and H the same.  Problem is i need the names to match up, there are names in row a and b that is not in the othere and row d and e there are names not in a and b and g and h.  Is there a command i can do in Excel to match up any names that are in A and B D and E and G and H.

Hoope this makes sense

Thanks

0
happyexchange
Asked:
happyexchange
  • 3
  • 2
1 Solution
 
TracyVBA DeveloperCommented:
What do you mean by match up?

Can you post what your expected results should look like?  Also a sample file of data would be nice too.
0
 
happyexchangeAuthor Commented:
Please see attachment and you will see what i mean.
So names in row A and B needs to match the names in D and E and G and H
Thank you.
AD-USERS.xls
0
 
TracyVBA DeveloperCommented:
OK, have a look at this.  I concatenated the 3 sets (so A & B is concatenated in column C, E and F into G and H and I into J).

I used this formula in column D to list out the values from the A & B set that were in BOTH of the other two sets:

=IF(AND(COUNTIF($G$3:$G$300,C3)>=1,COUNTIF($J$3:$J$182,C3)>=1),"In Both Lists","")
AD-USERS.xls
0
 
happyexchangeAuthor Commented:
Thank you so much
0
 
happyexchangeAuthor Commented:
Thank you again
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now