Excel: Populate a specific number of cells given a specific entry
Here was the question from @nurfnurder:
"But may I ask a complicated question? Is it possible to have a drop down list populate the cells below it? Context: I have a drop down list with the values 1 to 25. Is it possible for me to select one of those values and have a row auto populate with that number of cells in ascending order? i.e. I choose the number 12 from drop down, and a column populates with 1 on say C2, then 2 on C4, then 3 on C5, etc. etc.? I have been looking EVERYWHERE for an answer and no luck."
The answer involves formula, the row command, and a data list dropdown.
The main formula ended up being =IF((ROW(C2)-1)≤$C$1,ROW(C2)-1,"")
(note that ≤ is actually the less than sign and then the equal sign, but YT doesn't allow the real less than sign to be used)
Feel free to ask questions!