FORMULA COPY AGAIN!!!
 

Alright uing $'s worked for keeping things from moving around. New post! I
have a formula in a multiple / 100's of cells like this.

=SUMPRODUCT((Sheet1!$A$2:$A$4=3)*(Sheet1!$B$2:$B$4 =300)*(Sheet1!$C$2:$C$4={"C","P","S","T"})*Sheet1! $E$2:$E$4)

I want to change the first array value from =3 to =039 in all of them in one
worksheet at a time. Is there an easy way of this or is it going to be a one
by one process. Thanks for everyones help so far, and Thanks for the replies
in advance on this one.

Sean

FORMULA COPY AGAIN!!!
 

Hi Sean

=039 won't work
as numbers lose their leading zero when entered in Excel
do you mean
="039"

you could use edit / replace to do this ... (take a copy of your workbook
first)
e.g.
edit / replace
find what: =SUMPRODUCT((Sheet1!$A$2:$A$4=3)
replace with: ==SUMPRODUCT((Sheet1!$A$2:$A$4="039")

- under options choose "within workbook" and look in formulas

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Sean" wrote in message
...
Alright uing $'s worked for keeping things from moving around. New post!
I
have a formula in a multiple / 100's of cells like this.

=SUMPRODUCT((Sheet1!$A$2:$A$4=3)*(Sheet1!$B$2:$B$4 =300)*(Sheet1!$C$2:$C$4={"C","P","S","T"})*Sheet1! $E$2:$E$4)

I want to change the first array value from =3 to =039 in all of them in
one
worksheet at a time. Is there an easy way of this or is it going to be a
one
by one process. Thanks for everyones help so far, and Thanks for the
replies
in advance on this one.

Sean

FORMULA COPY AGAIN!!!
 

Probably first person with the wrong answer, but you should be able to do a
search and replace in Excel.
Search string: =3)
Replace string: ="039")

You can limit the search and replace function to the active sheet.

-Glenn ray

"Sean" wrote:

Alright uing $'s worked for keeping things from moving around. New post! I
have a formula in a multiple / 100's of cells like this.

=SUMPRODUCT((Sheet1!$A$2:$A$4=3)*(Sheet1!$B$2:$B$4 =300)*(Sheet1!$C$2:$C$4={"C","P","S","T"})*Sheet1! $E$2:$E$4)

I want to change the first array value from =3 to =039 in all of them in one
worksheet at a time. Is there an easy way of this or is it going to be a one
by one process. Thanks for everyones help so far, and Thanks for the replies
in advance on this one.

Sean