Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |