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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:37 PM.