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. |
Global Change Of Formula Value
On 21/10/2011 20:23, carl wrote:
=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);-- ($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956) ) Find and replace. David Biddulph |
Global Change Of Formula Value
On Oct 21, 2:23*pm, carl wrote:
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. Or you could just have defined names for your ranges and forget about it henceforth colA =offset($a$41,1,0,0,counta($a:$a)-41,1) colC =offset(cola,0,2) colC =offset(cola,0,2) cole =offset(cola,0,5) =(SUMPRODUCT(--(cole=549);--(LEFT(colc,2)=C$5);-- (colg="SailErrorNotice");cola)) |
All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com