Posted to microsoft.public.excel.misc

Darius

external usenet poster

Posts: 41

equation change

I have 5 sheets in a workbook and have 100 workbook like this. In each
worksheet I have about 10 equations which use data F3:F200 in sheet1 and
F3:F230 in sheet2 etc. Lets consider equations like =Average(f3:f200), =
Var(F3:F200), etc.

Now how can I change F3 to F93 for each of this equation in either one sheet
or the whole workbook?

Thanks for your help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need Equation	NIDAL	Excel Discussion (Misc queries)	1	June 23rd 09 09:20 AM
Equation	MDL	Excel Discussion (Misc queries)	4	May 20th 09 10:18 PM
if equation	Robert	Excel Worksheet Functions	0	February 2nd 06 04:01 PM
Equation Editor- problem when editing an equation	Gaby L.	Excel Discussion (Misc queries)	0	September 27th 05 09:24 PM
How do I peg 4 col in an equation so when i add one col it only l.	AVeraging Columns	Excel Worksheet Functions	1	November 12th 04 07:10 PM

All times are GMT +1. The time now is 10:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us