Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in Formulas
Hi
I have the following formula in a lot of cells. =SUMPRODUCT(--(DataDATE(2006,1,1)),--(Data<DATE(2008,1,1)),--(ISNUMBER(MATCH(MONTH(Data),{1},0)))) Is there a way to select all the cells involved with this formula and change the date entries in the formula all together at the same time as it will take a long time to go through every cell individually. Anyone have any ideas. Regards, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in Formulas
Found it, Sorted
"santaviga" wrote: Hi I have the following formula in a lot of cells. =SUMPRODUCT(--(DataDATE(2006,1,1)),--(Data<DATE(2008,1,1)),--(ISNUMBER(MATCH(MONTH(Data),{1},0)))) Is there a way to select all the cells involved with this formula and change the date entries in the formula all together at the same time as it will take a long time to go through every cell individually. Anyone have any ideas. Regards, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
need help w/ macro prompting with info and pasting the info based on user input | Excel Programming | |||
Need to keep some info from formulas, but then change the formula | Excel Worksheet Functions | |||
Formulas and making info invisible | Excel Programming |