Announcement

Collapse
No announcement yet.

List numbers between two values

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • List numbers between two values



    Hi all,

    I'll be buggered if I can sort this one myself; I have two Text boxes on a User Form, say 1 & 2 and when submitted these two values are pasted into two cells within a spreadsheet, what I can't figure out is how to have a list of all values between these values in a column, any ideas?

    I'll I can find is =IF(ROWS($1:1)+$Q$6>$S$6,"",ROWS($1:1)+$A$1) but this is only showing 1-9 and not 1-10.

    Thanks,
    Graham
Working...
X