Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Best to you
I have this formulas : =AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D 1;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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula will not work | Excel Discussion (Misc queries) | |||
Why does this Formula work? | Excel Worksheet Functions | |||
FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
My formula does not work! | Excel Worksheet Functions |