LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Auto-fill formulas Excel 2003

I have a simple calculation to make but must enter the formula multiple
times. Is there an easy way to do this?

I am collecting time points from multiple experiments, a t = 0 point and at
fixed intervals thereafter. The number of timepoints varies between
experiments. Showing arbitrary values, my spreadsheet is organized like this
with "Expt" in cell A1:

Expt time data value Calculation Formulas
A 0 1 1.0 =C2/$C$2
A 1 2 2.0 =C3/$C$2
A 2 3 3.0 =C4/$C$2
B 0 1.5 1.0 =C5/$C$5
B 1 2 1.3 =C6/$C$5
B 3 3 2.0 =C7/$C$5
B 4 4 2.7 =C8/$C$5
C 0 1.4 1.0 =C9/$C$9
D 0 1.8 1.0 =C10/$C$10
D 1 2 1.1 =C11/$C$10


What I need to do is calculate the change in values relative to the t = 0
timepoint for each experiment. I can enter the formulas for each t = 0 point
manually and then copy to the relevant cells. Is there an easier way?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
auto fill of formulas wpm Excel Discussion (Misc queries) 2 September 20th 06 11:16 PM
turn off auto fill options box Excel 2003 martock Excel Discussion (Misc queries) 2 October 13th 05 02:23 AM
Auto Fill and Excel 2003 Anne Troy Excel Discussion (Misc queries) 5 September 14th 05 09:36 PM
How do I auto fill formulas dorheldav Excel Worksheet Functions 1 January 25th 05 01:48 AM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"