Solved

=name coomand in Excel 2007

Posted on 2011-03-18
5
190 Views
Last Modified: 2012-06-27
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
Comment
Question by:happyexchange
  • 3
  • 2
5 Comments
 
LVL 24

Expert Comment

by:broomee9
ID: 35165991
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
 

Author Comment

by:happyexchange
ID: 35166167
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
 
LVL 24

Accepted Solution

by:
broomee9 earned 500 total points
ID: 35166308
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
 

Author Comment

by:happyexchange
ID: 35166464
Thank you so much
0
 

Author Closing Comment

by:happyexchange
ID: 35166476
Thank you again
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now