Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am working with a two page workbook. On page one I have upper and lower values of a range (example 0.0 to 5.0, or 0 to 100) and an increment value (example 0.2 or 5). On page two I would like a column to automatically fill with the series of values within the range according to the increment value.
For example: If the range on page one is from 0.0 to 5.0, and the increment is 0.2, I would like a column in page two to fill 0.0, 0.2, 0.4, 0.6, 0.8, 1.0, 1.2… …4.8, 5.0 in a column from top to bottom. I hope this is clear enough; I am not very versed in Excel vocabulary. Any help is appreciated. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I Generate Multiple Graphs for Different Series of Data | Charts and Charting in Excel | |||
how to generate series of random numbers which are all unique | Excel Programming | |||
Generate auto increment number from VB form | Excel Programming | |||
How do I increment a fill series by a number other than 1? Say I. | Excel Worksheet Functions | |||
how can i get formulaes to increment by one in a series of worksh. | Excel Discussion (Misc queries) |