| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Global Change Of Formula Value
I have several formulas in a spreadsheet. For example this one...
=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);-- ($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956) ) Is there a way to change the range from 22956 to 30000 ? I am trying not to have to go into each formula and make this change. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
| Graph data series formulas: How to global-change all sheet reference to formula | Excel Discussion (Misc queries) | |||
| How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
| Global change to cell values | Excel Discussion (Misc queries) | |||
| How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) | |||
Threaded Mode
