| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula in a makro want work
On Mon, 27 Aug 2007 04:18:00 -0700, Makelei
wrote: Hi Ron, Thanks for your answer, but: "=IF(LEFT(RC4,4)="Ext-",SUM(IF(Need!R8C6:Need!R21C6<"",IF(Need!R8C7:Nee d!R21C7=RIGHT(RC4,LEN(RC4)-SEARCH(" ",RC4)),IF(Need!R8C5:Need!R21C5<R4C2,IF(Need!R8C 5:Need!R21C5<R3C2,IF(Need!R8C5:Need!R21C5<R2C2,I F(Need!R8C5:Need!R21C5<R1C2,Need!R8C[14]:Need!R21C[14],0),0),0),0)))),SUM(IF(Need!R8C6:Need!R21C6="",IF( Need!R8C7:Need!R21C7=RC4,IF(Need!R8C5:Need!R21C5< R4C2,IF(Need!R8C5:Need!R21C5<R3C2,IF(Need!R8C5:Ne ed!R21C5<R2C2,IF(Need!R8C5:Need!R21C5<R1C2,Need! R8C[14]:Need!R21C[14],0),0),0),0)))))" Does not work either... Problem seems to be in ths bit: IF(Need!$G$8:Need!$G$21=RIGHT($D10,LEN($D10)-SEARCH(" ",$D10) Any proposals? BR MakeLei There is another potential problem and I don't know how to solve it. (Again, it would have been easier had you defined "does not work"). At least in excel 2003 and earlier, you cannot pass a formula that is longer than 255 characters. See http://support.microsoft.com/kb/213181/EN-US/ --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't seem to get my Array formula to work................ | Excel Discussion (Misc queries) | |||
| array formula does not work | Excel Worksheet Functions | |||
| Formula or makro help | Excel Programming | |||
| Will an Array Formula work here? | Excel Discussion (Misc queries) | |||
| old makro (excel 95) should work with vba-modules | Excel Programming | |||
Threaded Mode
