How to display running-down numbers with total count?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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),"")
 
Back
Top