How to list in a column with certain number

A

Angxin77

How can I type in a certain number in one cell and it comes out with th
list of numbers? For example if I input a number "10", it automaticall
shows a list of numbers from 1, 2, 3... to 10 in a column (not drop-dow
list) . Is there any function that can be used for this purpose? Than
yo
 
C

Claus Busch

Hi,

Am Thu, 11 Apr 2013 14:25:16 +0000 schrieb Angxin77:
How can I type in a certain number in one cell and it comes out with the
list of numbers? For example if I input a number "10", it automatically
shows a list of numbers from 1, 2, 3... to 10 in a column (not drop-down
list) . Is there any function that can be used for this purpose? Thank
you
Click to expand...

your number in A1. Then in A2:
=IF(ROW(A1)>$A$1,"",ROW(A1))
and copy down


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Space at end of multi page list to accommodate new entries 1
How to make repeating drop-down lists? 2
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Setting column width in a table with a macro is not working 0
Paragraph numbering in Word 1
Drop down list control value in vba 2

Top