| 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 | |||
Hybrid Mode
