Formula to populate column with text prefix then next number (ascending)

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to populate column with text prefix then next number (ascending)

FAQ

Thread Tools

Display Modes

02-04-2019, 02:35 PM

NBVC

Windows 10 Formula to populate column with text prefix then next number (ascending)

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

If you can insert a blank row above (and hide it, if desired), then you can add formula in C2, copied down:

=IF(B2="","",IF(LEFT(B2,7)="Section",TRIM(LEFT(B2, FIND("-",B2)-1)),"REQ-"&--SUBSTITUTE(LOOKUP(2,1/(LEFT(C$1:C1,7)="Section"),C$1:C1),"Section","")& TEXT(IF(LEFT(C1,7)="Section",1,RIGHT(LOOKUP(2,1/(C$1:C1<>""),C$1:C1),3)+1),"000")))

Tags

auto-numbered

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help me create a button to generate an ascending sequential reference number on a worksheet	Blue Owl	Excel Programming	1	05-24-2018 05:01 PM
If text in column then formula in other	Grubermen	Excel	1	09-06-2017 06:35 AM
Find entries lacking prefix and then add prefix.	gsteel	Excel	2	08-28-2017 11:36 AM
Shortcut to haven ascending values in row/column of cells	Straitsfan	Excel	1	08-09-2016 05:28 AM
Word 2007 TOC Section Number w/Alpha Prefix?	Gwen Butler	Office	2	09-29-2011 06:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 PM.