Forum Discussion
AdamDesrosiers
Mar 07, 2022Copper Contributor
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...
JKPieterse
Mar 07, 2022Silver Contributor
I'm not sure I understand your question, can you please state it in different words?
NB: from 2000 to 2100 is 101 items, not 100.
NB: from 2000 to 2100 is 101 items, not 100.
AdamDesrosiers
Mar 07, 2022Copper Contributor
JKPieterse Hello Jan,
I am trying to auto populate cells based on a range of numbers when you just input a number for the quantity. Does that help?
Yes, correct 101 not 100.