Hi, I’m looking for a formula to fill a cell with a range of numbers, with the minimum and maximum values coming from adjacent cells. For example,
cell A1 = 5
cell B1 = 8
cell C1 automatically fills with: 5,6,7,8
Thanks a lot!
(Supposing your “numbers” are exclusively unsigned integers.)
Until recently there was no reasonable way to accomplish this.
The attempt is most likely still questionable. It can, however, be accomplished now using the TEXTJOIN() function which was implemented first in V5.2.0 and since debugged.
See this attached example.
Very nice! Thank you so much for the comprehensive answer. Sorry I can’t upvote this answer because I don’t have enough points yet.