This problem is too simple for me to be able to find anything on google so far.
I want to create a column of numbers starting at some number (say 700) and ending at another number (1000). I know I could create cells for 700 and 701 and drag down, but for my purposes that takes too long. I also know I can highlight the range and press the keyboard shortcut (ctrl+d?) to autofill the cells.
However, I want to create a formula in the first cell that will fill in the next 200 or 300 or 1000 cells in a simple <cell = cell above + 1> series. Is this possible with a function?
Thanks in advance!
Hi Joe, welcome to the forum.
A function won't create a list like you're seeking. A macro could, or a series of functions in multiple cells.
For example, let's say you have the value 700 in A1 and 212 in B1. In A2 put the formula:
=IFERROR(IF(A1+1>$A$1+$B$1,"",A1+1),"")
Fill that down hundreds or thousands of rows. You'll end up with a list of numbers starting at 700 through 700 + 212 (912). Below row 212 will be blank (""). The IFERROR wrapper handles the VALUE errors that appear after the first blank of the inner IF statement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks