| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible to auto-fill in gaps between numbers on straight line bas
Guys,
I have some time series data but with gaps in between. Is there a way to get Excel to fill in the blanks between two numbers on a straight line basis? Eg: If I have in A1 the number 5 and in A4 the number 11, is there a way to automatically fill A2 with 7 and A3 with 9? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Straight Line is not straight | Excel Discussion (Misc queries) | |||
| straight line equation | Excel Worksheet Functions | |||
| straight line graph, really straight line.. | Excel Discussion (Misc queries) | |||
| best fit straight line | Charts and Charting in Excel | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Threaded Mode
