1. Registered User
Join Date
Dec 2002
Posts
24

I need to do a comparison in an Excel spreadsheet.

This is in relation to the first table seen at
http://bit.ly/afSuXt
Look at the first row of the table.

Mother:
14, 18

Child:
14, 15

Father:
15, 16

I have 3 sets of numbers. Each set has 2 numbers. The figures for the Child set should have come from both the mather and the father - that is, one from the mother, and the other from the father. If not then return FALSE.

Comparison 1. Compare Child with Mother. Is at least one of the numbers in Child seen in Mother?

In the example above, yes - 14 in Child is also seen in Mother.

Comparison 2. If the Comparison 1 is TRUE, then compare Child and Father using the figure that does NOT match in Comparison 1. That is, compare the value of 15 in Child with both figures in Father. If it is seen, the return TRUE.

How can this be resolved? I've used LOOKUP, IF, AND, OR etc, but am looking for an elegant solution.

2. Registered User
Join Date
Dec 2002
Posts
24
Does this attached Excel sheet make anything clearer?

3. Registered User
Join Date
Dec 2002
Posts
24
apologies - the first zipped file had external cell references. This one should work...

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•