Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2020, 10:42 AM
Benali Benali is offline Formula to add +1 to a sequence Windows 10 Formula to add +1 to a sequence Office 2013
Novice
Formula to add +1 to a sequence
 
Join Date: Apr 2020
Posts: 10
Benali is on a distinguished road
Default Formula to add +1 to a sequence


What formula would work to make the change from RE249869000xxx-00-xxxx-0001 to RE249869000xxx-01-xxxx-0001 and the next RE249869000xxx-02-xxxx-0001 and all the way to RE249869000xxx-99-xxxx-0001
Attached Images
File Type: png excel register numbers.PNG (14.1 KB, 17 views)

Last edited by Benali; 05-03-2020 at 01:30 PM.
Reply With Quote
  #2  
Old 05-03-2020, 03:33 PM
macropod's Avatar
macropod macropod is offline Formula to add +1 to a sequence Windows 7 64bit Formula to add +1 to a sequence Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For example:
="RE249869000xxx-" & TEXT(ROW()-1,"00")& "-xxxx-0001"
However, this isn't going to produce RE249869000xxx-99-xxxx-0001 on row 12. The logic for that result escapes me.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-03-2020, 06:59 PM
Benali Benali is offline Formula to add +1 to a sequence Windows 10 Formula to add +1 to a sequence Office 2013
Novice
Formula to add +1 to a sequence
 
Join Date: Apr 2020
Posts: 10
Benali is on a distinguished road
Default

That worked perfectly

now, can we make the 0001 go to 9999 in the same formula?
Reply With Quote
  #4  
Old 05-03-2020, 07:21 PM
macropod's Avatar
macropod macropod is offline Formula to add +1 to a sequence Windows 7 64bit Formula to add +1 to a sequence Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Really, that's a trivial change to the formula. How about studying it instead of expecting to be spoon-fed. Otherwise, you'll learn nothing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-04-2020, 05:51 AM
Benali Benali is offline Formula to add +1 to a sequence Windows 10 Formula to add +1 to a sequence Office 2013
Novice
Formula to add +1 to a sequence
 
Join Date: Apr 2020
Posts: 10
Benali is on a distinguished road
Default

I’ll try. Thanks
Reply With Quote
  #6  
Old 05-05-2020, 03:13 AM
CJustin CJustin is offline Formula to add +1 to a sequence Windows 10 Formula to add +1 to a sequence Office 2019
Novice
 
Join Date: May 2020
Posts: 9
CJustin is on a distinguished road
Default

If D is the column, In the column where you would like the new values output enter the formula =a1+$D$1 and copy down the column. Now whatever value you put in D1 will be added to the values in column A. if you want to subtract, just enter -1 into D1.
Reply With Quote
  #7  
Old 05-05-2020, 03:47 AM
macropod's Avatar
macropod macropod is offline Formula to add +1 to a sequence Windows 7 64bit Formula to add +1 to a sequence Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

CJustin: I have to wonder whether you bothered to read the question … or the answer in post #2.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to add +1 to a sequence Format in a formula month and numbers Marcia Excel 10 02-28-2019 05:55 AM
Formula to add +1 to a sequence How make IF Formula return a numbers joined with a letter Strogg Word 11 01-07-2019 03:13 PM
Formula to add +1 to a sequence Create a sequence of numbers using a formula 14spar15 Excel Programming 9 03-19-2018 01:15 AM
Formula to add +1 to a sequence Link to automated table and formula numbers Jacky837 Word 1 07-25-2016 10:45 AM
Formula to add +1 to a sequence Find & Replace formula for numbers? Griff Word 4 04-18-2011 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 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