Hi all,

I have 10 numbers to show from 1, 2, 3... 10 top-down (e.g., in Cell A1 to
A10)

What formula goes into a range, I bet an array formula, to diplsy those
number?

Criteria:
1. I would like to have flexibility of specifying how many numbers I want
from No.1 onwards (in the above example, 10).
2. The blank cells not showing numbers (e.g., A11 in the above example)
should display blank.

Nice and simple to you?

Thanks in advance.
Tetsuya, Singapore

Use cell D1 to enter how many numbers you want.

Enter this formula in A1 and copy down as needed:

=IF(ROWS(A$1:A1)<=D$1,ROWS(A$1:A1),"")

--
Biff
Microsoft Excel MVP


"Tetsuya Oguma" wrote in message
...
Hi all,

I have 10 numbers to show from 1, 2, 3... 10 top-down (e.g., in Cell A1 to
A10)

What formula goes into a range, I bet an array formula, to diplsy those
number?

Criteria:
1. I would like to have flexibility of specifying how many numbers I want
from No.1 onwards (in the above example, 10).
2. The blank cells not showing numbers (e.g., A11 in the above example)
should display blank.

Nice and simple to you?

Thanks in advance.
Tetsuya, Singapore