Changing a formula on the worksheet

  • Thread starter Thread starter Shashi Bhosale
  • Start date Start date
S

Shashi Bhosale

I have a worksheet with hundreds of formula, each formula has a option to
check for a site.
ex:
=SUMPRODUCT((DataSite="ABC")*
(DataAcc>=510115)*
(DataAcc<=510115)*
(DataAmount)
)

How do i change Site to 'XYZ' globally without goin to each cell and change
the formula to have site 'XYZ'.

Thanks in advance,

Shashi
 
Great.... Thanks.
Rafael Ortiz said:
Toggle the sheet to Formula View (CTRL + `), then do an Edit, Replace...
Then toggle back to regular view (CTRL + `)

Note: The ` is on the same key as the tilde (~).

MRO
Click to expand...
 
Back
Top