C
cpliu
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,