Create sequencial number list to use for Data Validation

Hi All,

I need a formula that I can use in order to create a list that I can use with Data Validation.

So cell D14 is where they enter the maximum number.

I need a list to be generated and for Data Validation to look at so that it can produce a list with D14 being the last number in the list.

Data Validation list: 1,2,3 ... (upto D14 value)

Numbers are always integers.

I hope that makes sense.

Create named range: I have called it "List" in the attached in Column C

Refers to: =OFFSET(Sheet1!$C$2,,,COUNT(Sheet1!$C:$C),1)

in C2

=IF(ROWS($1:1)<=$D$14,ROWS($1:1),"")

Copy down until blank )or to maximum value in D14)

in DV

Source: =List

Your formula worked perfectly, obviously had to do a few fiddles to make it fit my needs, but amazing. I always forget how useful formulas are in Name Manager.

Thank for the feedback and rep.