P
Paul Black
Good afternoon,
I have the formula ...
=SUMPRODUCT(COUNTIF(E10:J10,N10:S10))
.... which I have copied down in column "T" some 2,500 cells which
should always return the value 6.
Unfortunately the formula only works on about 80% of the formulas
although I know for a fact that the two sets of numbers match EXACTLY
and are values as opposed to text etc.
The only difference with the two sets of numbers to match is the first
six are not sorted numerically where as the second set of numbers are.
Thanks in advance,
Paul
I have the formula ...
=SUMPRODUCT(COUNTIF(E10:J10,N10:S10))
.... which I have copied down in column "T" some 2,500 cells which
should always return the value 6.
Unfortunately the formula only works on about 80% of the formulas
although I know for a fact that the two sets of numbers match EXACTLY
and are values as opposed to text etc.
The only difference with the two sets of numbers to match is the first
six are not sorted numerically where as the second set of numbers are.
Thanks in advance,
Paul