Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
find and replace formula text?
13 views
Skip to first unread message
cpliu
Jun 7, 2013, 10:42:28 AM6/7/13
to
Sometime people copy and paste item and push the cell down. Then my formula would stop working because one of the end cell location would be different from the others.
Is there a way I can find and replace formula text of all the cells in a document?
For example:
=SUMPRODUCT(--($A$3:$A$4841>=A422),--($A$3:$A$4841<=B422),--($B$3:$B$4841=D423),($E$3:$E$4800))
I'd like to replace D423 with D422
Thanks for your help,
Is there a way I can find and replace formula text of all the cells in a document?
For example:
=SUMPRODUCT(--($A$3:$A$4841>=A422),--($A$3:$A$4841<=B422),--($B$3:$B$4841=D423),($E$3:$E$4800))
I'd like to replace D423 with D422
Thanks for your help,
0 new messages