Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-16-2018, 10:39 PM
14spar15 14spar15 is offline Create a sequence of numbers using a formula Windows XP Create a sequence of numbers using a formula Office 2000
Advanced Beginner
Create a sequence of numbers using a formula
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Create a sequence of numbers using a formula

I’m trying to find a formula to create a sequence of numbers. The starting number would be in A1 and the ending number in B1. So if A1 = 88 and B1= 93 the result in the formula cell (C1) would be 88 89 90 91 92 93. I tried using =Row(Indirect(A1”;”&B1)) and I could get the correct results but I could not figure out how to deal with array results, such as copying the results and using in another application. I found some work arounds to use the array result but when I tried recording this into a macro it did not work correctly so I just want to go to a simple formula. Any ideals? Thanks
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequence numbers after each print MauricioPillon Excel 0 02-15-2018 08:11 AM
Create a sequence of numbers using a formula 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 01:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft