[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Data Comparison Excel or MS Access SQL

I have two spreadsheets with Fname, Lname and Email address in each.
I require to find exclusive matches based on criteria listed below.

i.   Users who FName, LName and Email address all Match.
ii.  Users who Email addresses match excluded i above.
iii. Users who FName, LName match excluding i & ii above.

Thanks for your help in advance.
0
ukpowo
Asked:
ukpowo
1 Solution
 
Rey Obrero (Capricorn1)Commented:
this can done better in access using queries..

upload a copy of the table.
0
 
gplanaCommented:
You should execute these queries:

For example for i. (first case) you can use:
SELECT FName, LName, Email, count(*) howMany
FROM yourTable
GROUP BY FName, LName, Email
HAVING count(*)>1;

You will see which FName, LName and Email combination are repeated (are present more than once) and you will see how many records do you have for any of these combinations.
0
 
Jeffrey CoachmanCommented:
I'm with capricorn1, ...post a sample of the table, but also include a clear graphical example of the exact output you need, based on the data in the sample table...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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