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:
An example of how the number looks at the end is: