• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autopopulate rows

Mayank

New Member
Hi guys,

My first post on chandoo.org....

My name is mayank and im from noida.


I need following help....

I need to auto populate rows in excel starting from 1 and equal to the figure of my choice.

Ex. if figure of my choice in A1=10 then A2:A11 should auto populate with nos. from 1 to 10


Thanks in advance....
 
Mayank

You could put this in A2

=IF(ROW()-1>$A$1,"",$A$1-($A$1-ROW()+1))

and copy down as far as you need
 
Back
Top