| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Formula into Array
Thanks for looking at this. I have checked through the help (F1) but somehow
or rather, just can't find the solution: What I wanna do is to substitute the 5450 with 6001 (the formula below). Coz the range has increased from 5450 to 6001. If I can slot this in, then I won't have to set the range everytime it grows. * CountA(Dbase!A:A) equals to 6001 Substiture K5450 and F5450 =SUMPRODUCT(--(Dbase!$K$1:$K$5450=VLOOKUP(DATE(YEAR($B$25),MONTH ($B$25)-1,DAY(1)),Calendar,2,FALSE)),--(Dbase!$H$1:$H$5450=$B19),Dbase!$F$1:$F$5450) Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting hard CR in a formula | Excel Worksheet Functions | |||
| Formula for inserting blank row | Excel Worksheet Functions | |||
| mantaining formula when inserting col | Excel Discussion (Misc queries) | |||
| inserting a formula | Excel Discussion (Misc queries) | |||
| Formula changes while inserting a row !!!! | Excel Worksheet Functions | |||
Threaded Mode
