Ask Your Question

Fill a cell with range of numbers based on adjacent cell?

asked 2017-07-07 23:22:15 +0100

sb56637 gravatar image

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-07-07 23:57:30 +0100

Lupp gravatar image

(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.

edit flag offensive delete link more


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.

sb56637 gravatar imagesb56637 ( 2017-07-08 00:55:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-07 23:22:15 +0100

Seen: 37 times

Last updated: Jul 07 '17