I would like a function to add sequential numbers to a class number/name

		Microsoft Office Forums > Microsoft Excel > Excel
I would like a function to add sequential numbers to a class number/name

FAQ

Thread Tools

Display Modes

01-19-2016, 12:29 PM

Highlander01 Highlander01 is offline

Windows 10 I would like a function to add sequential numbers to a class number/name

Office 2016

Novice

Join Date: Jan 2016

Location: Portsmouth, England

Posts: 18

Quote:

Originally Posted by Kevin@Radstock

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

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
Excel simplify formula - array of sequential numbers	Wries	Excel Programming	1	05-12-2014 08:32 AM
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