How to list values between values in two cells.

[daverix]

This should be simple but I just can't figure it out. I have two columns of data containing numbers. For example, column A 2000 and column B 2005. I want a formula that will put the values between those two into the columns to the right and stop when it reaches the value in column B. Or better yet, place all the values in column C and separate them with a comma.

[AliGW]

Welcome to the forum.

Please provide a sample workbook showing a few lines of mocked up data as you wish to see it. Instructions in the yellow banner at the top of this page.

[daverix]

Thanks for the super quick reply. If I've done this right there should be an example of what I have. I am trying to get unique values between A&B in the adjacent cells or what would be perfect would be the values separated by commas in column C.

[AliGW]

You have not mocked up the results you want to see - please do so and attach the workbook again.

[daverix]

In an ideal world, this.

[Phuocam]

Not tested.

=TEXTJOIN(",",TRUE,ROW(INDIRECT(A2&":"&B2)))

Enter with Ctrl+Shift+Enter

[daverix]

Fantastic! Thank you.

[Richard Buttrey]

I'd been working on a solution assuming you didn't have Excel without realsing that Office365 automatically includes that. I hadn't realised that - lesson learned.

However for anyone coming later who doesn't have TEXTJOIN available here's a function that addresses your particular request. i.e. with a maximum of 4 numbers in the range.

Please Login or Register  to view this content.