Create a sequence of numbers using a formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Create a sequence of numbers using a formula

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-17-2018, 10:53 AM

xor

Windows 10 Create a sequence of numbers using a formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sequence numbers after each print	MauricioPillon	Excel	0	02-15-2018 08:11 AM
Wildcards - Sequence of Numbers at the Beginning of Each Paragraph	qubie	Word	1	11-30-2017 02:03 PM
How to assign numbers to letters and then create a formula to add them together for a rota	Mskapri	Excel	6	04-01-2017 03:05 PM
Need Help Deleting Numbers in Hour Format and Numbers in Sequence	rsrasc	Word VBA	1	10-12-2016 02:49 PM
How to Create a Locked Sequence of Buttons	kcackin	PowerPoint	0	01-24-2011 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 PM.