Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-fill formulas Excel 2003
One simple play to get there
Source data as posted, from row 2 to 11, with time in col B In D2: =IF(B2=0,C2,"") Copy down to D11 In E2: =D2 In E3: =IF(D3="",E2,D3) Copy E3 down to E11 (Col E will "fill col D down from above") Then in F2, copied down: =C2/E2 returns the required results -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "johnston" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-fill formulas Excel 2003
Max,
Very elegant. Very simple. Thank you very much! "Max" wrote: One simple play to get there Source data as posted, from row 2 to 11, with time in col B In D2: =IF(B2=0,C2,"") Copy down to D11 In E2: =D2 In E3: =IF(D3="",E2,D3) Copy E3 down to E11 (Col E will "fill col D down from above") Then in F2, copied down: =C2/E2 returns the required results -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "johnston" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-fill formulas Excel 2003
Welcome, Johnston.
Glad it helped. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "johnston" wrote in message ... Max, Very elegant. Very simple. Thank you very much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
auto fill of formulas | Excel Discussion (Misc queries) | |||
turn off auto fill options box Excel 2003 | Excel Discussion (Misc queries) | |||
Auto Fill and Excel 2003 | Excel Discussion (Misc queries) | |||
How do I auto fill formulas | Excel Worksheet Functions |