Forum Discussion
Formula Help, auto fill finite amount of cells based on a quantity and in between specific range
Hello all, I am trying to auto fill an excel sheet within a specific range of serial numbers based on a fixed quantity. For example, If I have serial number range 2000 to 2100 I want to auto p...
AdamDesrosiers If you have Excel for MS365 or 2021, you could use SEQUENCE to create the type of serial number table you describe. For instance,
=TRANSPOSE(SEQUENCE(10,100,2000,1))
will create a matrix, 10 columns wide, 100 rows long, starting at 2000. Starting at 2000, going down to 2099 and then starting again in the next column start at 2100 and so on. Adapt the number of columns to your needs.
Unfortunately, our workplace only has MS excel 2013, so we can't use that function.
What I really need is for the person to just input a number in the quantity cell and populates the cells based on the quantity and in between the serial number range.
Hope that makes sense.