make a list from the beginning and the end

A

Albert

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
 
B

Bob Umlas, Excel MVP

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
 
C

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
 
Top