Thread
: [Solved]
Create a sequence of numbers using a formula
View Single Post
03-17-2018, 10:53 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
If you want
88;89;90;91;92;93 in C1 you can use the following array formula (on condition you have Office 365):
=TEXTJOIN(";",TRUE,(ROW(INDIRECT(A1&":"&B1))))
Array formulas must be completed by holding down Ctrl and Shift before pressing Enter.
xor
View Public Profile
Find all posts by xor