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
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