Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 04-01-2018, 08:10 AM
ArviLaanemets ArviLaanemets is offline Continuing a certain sequence in Excel Windows 8 Continuing a certain sequence in Excel Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by rooly View Post
The table you uploaded stops at 01-04-05 . How do I continue on to 01-05-01 Etc..
Limit1 or whatever it was (I don't have Excel currently so I'm not sure how I named them exactly) (at top of page are 3 limits, btw you can have them on separate sheet, or you can simply define them as names when those limits are fixed) determines the max number allowed in 1st 2 characters of code, and as result the range the formulas calculate the code for. So set the Limit1 to 99, and you get the max of the table with current Limit2 and Limit3.

Wait! At 01-04-05! I have to check the formula, but it takes some time. I have to connect to another computer.

It stops at 03-04-05 - what is right as Limit1=3, Limit2=4 and Limit3=5.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Defining New Headings, but continuing numbering. Cpeck3 Word 1 03-14-2018 09:34 AM
Continuing bullet point numbers Se7encm PowerPoint 0 03-12-2017 02:57 AM
Continuing a certain sequence in Excel Need an excel formula to remove dashes in a number sequence jyfuller Excel Programming 3 02-27-2013 10:32 PM
Continuing a certain sequence in Excel Pausing a Macro for User Selection and continuing anirudhsood Word VBA 1 09-04-2012 08:34 PM
Continuing a certain sequence in Excel Excel sheet Sequence Number belloffice Excel 1 02-25-2010 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 AM.


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