Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    24

    Unanswered: Child, Mother, Father

    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. #2
    Join Date
    Dec 2002
    Posts
    24
    Does this attached Excel sheet make anything clearer?
    Attached Files Attached Files

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

Posting Permissions

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