Fill a column with numbers up to CERTAIN VALUE...is it possible with formula?

[PP3321]

If Cell A2 = 5, then
I want to fill the column A from 1 to 5 automatically.
*the starting location does not matter...

Please see image below.

Can we do this using formula...?

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[PP3321]

Wow thank you so much for quick post...if I could, I would give you 1000 likes...the formula is so beautiful...

 

[bosco_yip]

Another option using Text function,

In A6, copy across down :

=TEXT(ROWS($1:1),"[<="&A$2&"]0;")

Regards
Bosco

 

[PP3321]

@bosco_yip
wow I have never seen such formula before...I do not understand it but looks great! Thank you so much!!!

 

[PP3321]

@bosco_yip

Thank you for workbook too. It is amazing.

I googled to learn your formula.
I learned that you are using Custom Number Format with conditions.
I did not know anything about this so thank you!

http://simoncpage.co.uk/blog/2008/09/excel-custom-and-conditional-number-formatting/

 

[Somendra Misra]

Hi,

Using @NARAYANK991 sir file another option can be below formula in cell A6 and copy down and across.

=IF(ROWS(A$6:A6)>A$2,"",MOD(ROWS(A$6:A6),A$2+1))

Regards,

 

[PP3321]

@Somendra Misra
Thank you!!!!!!