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

"Albert" wrote:

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