Compare two datasets and extract unique records from each

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

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

  • RE: Compare two datasets and extract unique records from each
    ... Have you tried Advanced Filter Unique Records? ... compare two lists with single columns, but I need a very basic guide ... 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: The Bushkultie Hates America
    ... While lists kindly situate spines, the contexts often highlight ...
    (comp.os.linux.misc)
  • 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: sorting code
    ... This highlighted cells A1 to A5. ... if I simply add data to column A in "Lists" the correct cells are ... Private Sub Worksheet_Change ... highlight the code and click the "Comment Block" icon on the ...
    (microsoft.public.excel.misc)
  • 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)