Comparing Repeating Cells

  • Thread starter Thread starter dkenebre
  • Start date Start date
D

dkenebre

How do you express a formula for the following examples

If A2, B2 and C2 all cells with same numbers as A1, B1 and C1,
in any order, then D1 equals 3, (ie 3,,7,,2 followed by 3,,2,,7)
but
If A2, B2 and C2 have only 2 cells which is the same as A1, B1 and C1,

in any order, then D1 equals 2,
(ie 3,,7,,2 followed by 2,,3,,4) or (ie 3,,7,,2 followed by 3,,7,,7)
but
If A2, B2 and C2 have only 1 cell which is the same as A1, B1 and C1,
in any order, then D1 equals 1,
(ie 3,,7,,2 followed by 0,,2,,4) or (ie 3,,7,,2 followed by 3,,3,,8)
or ie 3,,7,,2 followed by 2,,2,,2
but
If A2, B2 and C2 have no cells which are the same as A1, B1 and C1, in
any order, then D1 equals 0,
ie 3,,7,,2 followed by 4,,1,,9
 
Back
Top