Solved

Data Comparison Excel or MS Access SQL

Posted on 2013-11-01
3
91 Views
Last Modified: 2014-03-25
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
Comment
Question by:ukpowo
3 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 39617001
this can done better in access using queries..

upload a copy of the table.
0
 
LVL 15

Expert Comment

by:gplana
ID: 39617022
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 39617270
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

920 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

12 Experts available now in Live!

Get 1:1 Help Now