Sequential Number

09/16/20
Answered - Pending Review

I am creating a Project Numbering system in a sheet that are generated based on selected criteria's. The last 3 digits would need to be sequential numbers "000"

Auto-numbering will not work for this application as the criteria's differ for each program.

Follow is what the formula looks like in excel:

&TEXT(COUNTIF($B$2:B3,B4)+1,"000")

An example of how the number looks at the end is:


Popular Tags:

Answers

Sign In or Register to comment.