RE: Compare two datasets and extract unique records from each

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Michelle
Have you tried Advanced Filter Unique Records?

"toadflax@xxxxxxxxxxxxx" wrote:

Hi,

I am struggling a bit with this problem--I can find lots of ways to
compare two lists with single columns, but I need a very basic guide
to comparing multiple ones across two sets of data and then
highlighting or extracting the unique records.

I currently have the two datasets as two separate worksheets in an
Excel file. The two datasets consist of the same three columns
containing strings of text, but there is quite a difference in the
number of rows. Dataset One is c. 3550 records, Dataset 2 is c. 1600.
There are no duplicate records within each dataset, but there are
duplications across the datasets and the records are in a different
order, so it's not a matter of comparing Row 1 to Row 1 and so on. The
data look a bit like this (semi-colons to show columns):
DATASET 1
Group;Family;Name
PM;Smith;Mary Anne
PM;Jones;Fred Henry
PD;Wilson;Peter John
PG;Green;William Laurence
....

DATASET 2
Group;Family;Name
PM;Jones;Ralph John
PD;Smith;Fred Anthony
PM;Smith;Mary Anne
....

What I want is:
(a) a list of the records that are in Dataset One but NOT in Dataset
Two (or a way to highlight these records) and
(b) a list of the records that are in Dataset Two but NOT in Dataset
One (or a way to highlight these records).
There may also be records with missing data/blanks in any one of the
fields and I would like these to be highlighted or extracted as well,
if they are unique to one dataset.

Is this at all possible? Any help would be greatly appreciated!


Thanks in advance,
Michelle

.

Relevant Pages

  • Compare two datasets and extract unique records from each
    ... compare two lists with single columns, but I need a very basic guide ... There are no duplicate records within each dataset, ... so it's not a matter of comparing Row 1 to Row 1 and so on. ... One (or a way to highlight these records). ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can a simple a==b hang in and endless loop?
    ... comparing only two 'values'. ... Coming from C or Javascript one would ... over all elements of the lists. ... 'is' does the C, Javascript job when comparing lists, but I mean it fails to give fully predictable results when applied to elements of lists in case there exist duplicate objects with same 'value' i.e. e.g. there are two different objects storing the integer value 1, what I mean can happen when there is enough other code between the Python code lines assigning the integer value 1 to a list element or any other identifier. ...
    (comp.lang.python)
  • Re: expandable test if token-lists consist of the same set of tokens?
    ... \detokenize-ation of the two lists are the same, ... Check if it is possible to strip off surrounding braces (a ... I think you can test this by comparing \detokenize ... Otherwise terminate with \@secondoftwo. ...
    (comp.text.tex)
  • Re: Finding Closest Text Match
    ... was using that as an example of comparing entries in two lists). ... My lists are not huge so I some degree of assessment of the results is not ... Basically I was trying to do a VLOOKUP based on a list of names and a second ... Parker on Main Street may or may not be the same Bob Parker on Second ...
    (microsoft.public.excel.programming)
  • Re: List Flatten
    ... Removing them (we expand lists only) we obtan the short ... In may book all three versions (Alex Martelli's yours and mine) use the ... _same_ flattening algorithm with _different_ methods to test for atomicity. ... somebody thought that comparing them was a good idea :-), but again, it ...
    (comp.lang.python)