Search code examples
excelexcel-formula

Formula for generating delimited list of incremented numbers

Looking for a formula that takes a min and max value, then generates a delimited list of numbers including and between those values.

For example:

min = 2015

max = 2017

result = 2015,2016,2017

Not sure what to call it/how to word it, everything I've tried gives me results unrelated.

Solution

  • You may try

    =TEXTJOIN(",",,SEQUENCE(1,3,2015,1))