#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 191
Default Filling in Data

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Filling in Data

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Filling in Data

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
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
filling down to the end of a data set automatically eklem Excel Discussion (Misc queries) 2 April 23rd 09 05:45 PM
Inserting a row and filling in data Idolminder Excel Discussion (Misc queries) 1 October 22nd 08 06:51 PM
Filling in data when... pm Excel Worksheet Functions 3 December 15th 06 01:54 AM
Filling in missing data filky Excel Discussion (Misc queries) 5 June 23rd 06 02:41 PM
filling information from one cell and filling another. Dianne Excel Worksheet Functions 1 August 15th 05 08:14 PM


All times are GMT +1. The time now is 09:30 PM.

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"