Divide a range evenly across cells given min and max

[pambree]

Occasionally, I need to disperse amounts between a min and max evenly, and the number of slots between the amounts may change the next time I need to do that. For example, if we have a position that earns a minimum salary of $2,345 per month with 0 years of experience (the number in cell A1) and $3,456 per month after 5 years of experience (the number in cell A6), then I'd like to be able to do some sort of easy autofill to get the amounts between (see the example shown below). The next time, I might need to go from 0 years to 30 years, so the setup would change slightly from time to time. Now, I can do this with a formula, but if there were a way to type in the min and max in the appropriate cells and then populate the cells between without writing a formula, that would be great - perhaps some sort of autofill option. Is there a way to do that? I figure if I need to do this, others must, so I am hopeful that someone has discovered a way. Thanks!

Cell Exp Sal
A1 0 $2,345.00
A2 1 $2,567.20
A3 2 $2,789.40
A4 3 $3,011.60
A5 4 $3,233.80
A6 5 $3,456.00

[mikeTRON]

There are ways to do that, but will there always be 4 empty spaces and a beg and end point?

[mikeTRON]

Ehh, I went ahead and through something together. It is attached below and should be straightforward.

MinMax Salary.xlsx

Let me know if you have any questions.


EDIT:

You can also do this with AUTOFILL if you type your min in cell A1 then max in cell A6 then select A1:A6.
Clcik on the drop down for FILL on the home tab, then click on Series.
Now either delete the step value of 1, OR click on the trend button.
Hit ok and both of those options tend to work for me.

(HOTKEY alt+E I S does the same)

[chidama]

Auto fill series didn't work for me. I am looking for filling values in percentage.

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar or even the same to this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread