Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# =name coomand in Excel 2007

Posted on 2011-03-18
Medium Priority
239 Views
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
Question by:happyexchange
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 3
• 2

LVL 24

Expert Comment

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

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.
0

LVL 24

Accepted Solution

Tracy earned 2000 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","")
0

Author Comment

ID: 35166464
Thank you so much
0

Author Closing Comment

ID: 35166476
Thank you again
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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 will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month9 days, 10 hours left to enroll

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

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