Changing Multiple Formulas

S

stevieboy1313

We are working with some pretty good size worksheets that have multiple
formulas. How can I change a reference in several formulas all at once,
without changing the rest of the formula? For example, I have one formula
that reads;
=COUNT(EV29:EV268),
and then we have =IF(EW12=0,"-",IF(EW12=1,0,STDEV(EW29:EW258)))
and =IF(COUNT(EW29:EW258)=0,"-",MAX(EW29:EW258)) just to name a few.

How can I change all of the formulas on the sheet to reference row 268?
 
D

Don Guillett

Select all cells with formulas>edit replace>ew258 with ew268. Or use a macro
that also tests for only formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic update to SUM formula cell references. 6
Formulas That Reference ADJACENT Sheet 4
Can you use a formula to edit another formula in excel? 4
Moving cells without changing their formulas 3
Changing Multiple Formulas 2
Hiding Errors for formulas 3
Another Array Mystery 4
insert blank row and formulas 1

Top