Filling in Data
in [General]
|
Prev: Anchoring dialog boxes Excel 2007
Next: Combining rows with duplicate names - sum numeric, concatenate str
From: Jamie on 2 Mar 2010 14:25 I have several points where I need data. I only have the start and the end values and I want to fill in each of the points between the two. How is that accomplished. Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.
From: Bob I on 2 Mar 2010 14:38 550/9 = the increment to add moving from point 2 to point 9 Jamie wrote: > I have several points where I need data. I only have the start and the end > values and I want to fill in each of the points between the two. How is that > accomplished. > > Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.
From: Mike H on 2 Mar 2010 14:40
Hi, Try this and enter data into cells A1=50 a10=600 Select A1 to A10 then Edit|Fill|Series Ensure 'Columns' and 'Linear' are selected and Excel will work out the step for a linear growth from 10 to 600. OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jamie" wrote: > I have several points where I need data. I only have the start and the end > values and I want to fill in each of the points between the two. How is that > accomplished. > > Example. Point 1 = 50, Point 10 = 600. I need Points 2-9. |