Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last improvement in my project
Good day to everybody
I have this 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 own locale formula sintax : =AND(MMULT(TRANSPOSE(ROW(B1:F5))^0;ISNUMBER(B1:F5) *{1|0|1|0|1})<=1) It works well , but I wish to have some lasts improvements in it , for a better speed according with this ideea (please very much to read here) : http://www.decisionmodels.com/optspeedk.htm http://www.decisionmodels.com/optspeedj.htm [Why I need speed in this formula is because I'll work with hundreds of workboobs and millions of this kind formula ] 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 ? Maybe it take a smaller time for calculate it by excel 2003 application . Thanks through this way for enormous help of Dave D-C , Dave Peterson , Joel , Harlan Grove and many last but not list anothers ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Improvement | Excel Programming | |||
Is there a template for a home improvement project overview? | Excel Discussion (Misc queries) | |||
Improvement for office | Excel Discussion (Misc queries) | |||
Timer function needs improvement | Excel Worksheet Functions | |||
HLOOKUP improvement? | Excel Worksheet Functions |