I want to fill a column with the numbers from a specific range automatically.
For example, I have this range [-1;1]
and I want Excel to calculate the step and fill whole the range despite the amount of cells I selected.
If I select 3 cells, it should do this:
-1
0
1
If I select 11 cells, this:
-1
-0,8
-0,6
-0,4
-0,2
0
0,2
0,4
0,6
0,8
1
etc. And it should work for any range I want. Is it possible?