Solved

Compare names for mismatch

Posted on 2014-09-18
6
63 Views
Last Modified: 2014-09-18
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
Comment
Question by:CMILLER
  • 4
6 Comments
 

Author Comment

by:CMILLER
ID: 40331525
Office Excel 2007
0
 
LVL 6

Expert Comment

by:johnb25
ID: 40331642
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

by:CMILLER
ID: 40331649
I have two seperate export lists of names from two different systems and they should equal but they dont.
0
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 

Author Comment

by:CMILLER
ID: 40331655
I am getting a false on the first one and I know its true. The name matches
0
 
LVL 31

Accepted Solution

by:
Paul Sauvé earned 500 total points
ID: 40331675
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

by:CMILLER
ID: 40331690
Paul, yes that will work. Thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

821 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