Y
ytayta555
Best to you
I have this formulas :
=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D1;D3;D5)<=1;COUNT(E1;E3;E
5)<=1;COUNT(F1;F3;F5)<=1)
An perfect equivalent for this formula is the next array formula :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0,ISNUMBER(B1:F5)*{1;0;1;0;1})<=1)
in US formula sintax , and in my sintax :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0;ISNUMBER(B1:F5)*{1|0|1|0|1})<=1)
________________________________________
Thanks to mr. Harlan Grove I get this formula , which mr. Harlan Grove
said it
is another perfect equivalet for the formulas above ; the new
equivalent is :
=AND(COUNT(MATCH(ROWS(B1:F5);TRANSPOSE({1;3;5}))>=1))
but this formula didn't work stil for me ; can anybody give me the
changes in this last formula
to get it work ?
Thanks very much for your time and knowledge
I have this formulas :
=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D1;D3;D5)<=1;COUNT(E1;E3;E
5)<=1;COUNT(F1;F3;F5)<=1)
An perfect equivalent for this formula is the next array formula :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0,ISNUMBER(B1:F5)*{1;0;1;0;1})<=1)
in US formula sintax , and in my sintax :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0;ISNUMBER(B1:F5)*{1|0|1|0|1})<=1)
________________________________________
Thanks to mr. Harlan Grove I get this formula , which mr. Harlan Grove
said it
is another perfect equivalet for the formulas above ; the new
equivalent is :
=AND(COUNT(MATCH(ROWS(B1:F5);TRANSPOSE({1;3;5}))>=1))
but this formula didn't work stil for me ; can anybody give me the
changes in this last formula
to get it work ?
Thanks very much for your time and knowledge