Solved

# Compare names for mismatch

Posted on 2014-09-18
60 Views
I need to compare sheets 1 & 2 and have the missing names in sheets 3 & 4.

Compare sheet 1A & 2A export missing names to sheet 3A

Compare sheet 2A & 1A export missing names to sheet 4A

name = Last, First middle ( all in col A )
0
Question by:CMILLER
• 4

Author Comment

Office Excel 2007
0

LVL 6

Expert Comment

This will check Sheet1 if the name in A1 exists in Col A of Sheet2:
=IF(COUNTIF(Sheet2!A:A,Sheet1!A1)>0,Sheet1!A1,"")

It can be amended, depending on what you are comparing to what.
I am not entirely clear from the details you provided.

John
0

Author Comment

I have two seperate export lists of names from two different systems and they should equal but they dont.
0

Author Comment

I am getting a false on the first one and I know its true. The name matches
0

LVL 31

Accepted Solution

Paul Sauvé earned 500 total points
Please see my attached example. Every test with a value of 1 appears in both lists...Demo.xlsx

=COUNTIF('Blues Rock 1'!\$B\$2:\$B\$83;\$B2)

In reality, you only have to check one of the two lists!
0

Author Comment

Paul, yes that will work. Thanks.
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

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

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

#### Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!