Create a sequence of numbers using a formula

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

FAQ

Thread Tools

Display Modes

03-17-2018, 03:50 AM

xor

Windows 10 Create a sequence of numbers using a formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

If you want the numbers between value in A1 and value in B1 as an array, try:

=ROW(INDIRECT(A1&":"&B1))

This formula does not require array-entering.
Select the cell with above formula and press F2, then F9 and you should see the numbers between 88 and 93 if you have 88 in A1 and 93 in B1.

« Previous Thread | Next Thread »

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 02:47 AM.