make a list from the beginning and the end

[Guest]

Hi All,

Please help me with this problem if you can.
I have 2 numbers of a range, the first one and the last one.
I have to find out the numbers in the middle of these 2 points.
eg: I know
1 is the first number
20 is last number.
I have to know which numbers are in the middle: 2, 3, 4, 5, etc... 19.
And they should be written in different rows under each other.

So, I have a range of numbers, I know the first and the last one, and want
to find out the numbers in the middle.

Please help me to solve this problem.

Thanks a lot for your help, if you have any questions, just ask me.

Best Regards,

Albert

 

[Guest]

If I inderstand you, select all the cells from the first to the last, then
use edit/fill/series, and simply click OK - the rest of the cells should fill
in accordingly.
Bob Umlas
Excel MVP

 

[CLR]

There's not really any way it can be done with only the information you've
given..........one would need to know the quantity of increments between the
two numbers, and the type of spacing, linear, logrithymic, etc........

Vaya con Dios,
Chuck, CABGx3