Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filling down to the end of a data set automatically | Excel Discussion (Misc queries) | |||
Inserting a row and filling in data | Excel Discussion (Misc queries) | |||
Filling in data when... | Excel Worksheet Functions | |||
Filling in missing data | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions |