Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page I would like a function to add sequential numbers to a class number/name I would like a function to add sequential numbers to a class number/name
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2016, 07:35 AM
Highlander01 Highlander01 is offline I would like a function to add sequential numbers to a class number/name Windows 10 I would like a function to add sequential numbers to a class number/name Office 2016
Novice
I would like a function to add sequential numbers to a class number/name 		 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default I would like a function to add sequential numbers to a class number/name
Hi all

I need some help please.

I have a formula to input the information from one cell to another if there is something in the originating cell. =IF('Class Info'!A5=0,"",'Class Info'!$C$1). Happy with that. However, I now need to add sequential numbers to this

I have ABCD1234 entered in cell C1 (a cell in the 'class info' sheet) and I would like this class number in another sheet ('Format sheet' GF5) that will add a hyphen and sequential numbering, resulting in:
ABCD1234-1
ABCD1234-2
ABCD1234-3
Etc

I have also posted a similar post in Word but it is probably best done in excel and then the field added to the document and populated when merged.
Hope this makes sense.



G
Reply With Quote
  #2  
Old 01-16-2016, 09:54 AM
Kevin@Radstock Kevin@Radstock is offline I would like a function to add sequential numbers to a class number/name Windows 10 I would like a function to add sequential numbers to a class number/name Office 2016
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
As you have not posted a sample sheet. If those ABCD1234 in A1:A3, in B1 use:
"=A1&"-"&ROW()" & copy down.
Reply With Quote
  #3  
Old 01-17-2016, 04:49 PM
macropod's Avatar
macropod macropod is offline I would like a function to add sequential numbers to a class number/name Windows 7 64bit I would like a function to add sequential numbers to a class number/name Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
You also asked about this in another thread: https://www.msofficeforums.com/mail-...as-merged.html

Please don't ask what is essentially the same question in multiple threads.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-19-2016, 12:29 PM
Highlander01 Highlander01 is offline I would like a function to add sequential numbers to a class number/name Windows 10 I would like a function to add sequential numbers to a class number/name Office 2016
Novice
I would like a function to add sequential numbers to a class number/name 		 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default
Quote:
Originally Posted by Kevin@Radstock View Post
As you have not posted a sample sheet. If those ABCD1234 in A1:A3, in B1 use:
"=A1&"-"&ROW()" & copy down.
Excellent!
Thank you very much Kevin, greatly appreciated.

In addition - Is there a way to adapt the formula so that the cells in column B will remain blank until there is something (ABCD1234) in column A If the formula was already in place?

Regards

G
Reply With Quote
  #5  
Old 01-20-2016, 10:51 AM
Kevin@Radstock Kevin@Radstock is offline I would like a function to add sequential numbers to a class number/name Windows 10 I would like a function to add sequential numbers to a class number/name Office 2016
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
Hi G

=IF($A2="","",A2&"-"&ROW())
Reply With Quote
  #6  
Old 01-22-2016, 02:29 PM
Highlander01 Highlander01 is offline I would like a function to add sequential numbers to a class number/name Windows 10 I would like a function to add sequential numbers to a class number/name Office 2016
Novice
I would like a function to add sequential numbers to a class number/name 		 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default
Quote:
Originally Posted by Kevin@Radstock View Post
Hi G

=IF($A2="","",A2&"-"&ROW())
Fantastic Kevin. Thank you very much, you're a star.

Regards

G
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
wildcard search and add (not replace) sequential numbers in front equalizer88 Word VBA 4 05-07-2016 08:04 PM
I would like a function to add sequential numbers to a class number/name Excel simplify formula - array of sequential numbers Wries Excel Programming 1 05-12-2014 08:32 AM
I would like a function to add sequential numbers to a class number/name Creating a TOC with sequential letters instead of page numbers at the right margin shansen Word 1 03-11-2014 12:43 PM
Sequential Numbering on Tickets Multiple number Sequences skitchen Word 2 10-01-2013 06:41 AM
Labeling sequential forms with a unique number krau0231 Word 1 10-18-2012 03:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.

Contact Us - Privacy Statement - Top

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