How to fill values with equal increments between two cell values predefined?

Question

Hello everyone,

I need your help please.

Are there any simple methods to fill the values between two different cells in same column with equal increments starts with lower cell value and reach the last upper value of cell.

Any formulas, tricks?

Answer 1

B8:  70

B12: 76

B9: =B8+($B$12-$B$8)/(ROW($B$12)-ROW($B$8))

drag down

Answer 2

Do I have to do this every time with multiple values in columns and rows?

Yes. But since the number of cells between each number is the same we can use a trick to make it a bit easier:

Apply the formulas into the cells A2:A5 as I suggested.

Select A2:A5 and remove the $ from the formulas using Search&Replace

Copy A2:A5, select A7 and paste. Select A12 and paste... etc.

Andreas.

Answer 3

Thank you very much. This works efficiently.

Thank you for making the community better.