Forum Discussion

Nattiemick's avatar
Nattiemick
Copper Contributor
Dec 13, 2021

Creating a unique serial number in a database

So I'm hoping someone can help. I have 2 employees entering data into a database. What I am looking to do is, when they type information into a row it creates a serial number starting with their...
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Dec 13, 2021

Hi Nattiemick 

 

You may use the below formula to generate a unique serial number against each employee.

=LEFT(C2)&MID(C2,FIND(" ",C2,1)+1,1)&TEXT(ROW(C2),"0###")

 

Please refer to the attached file for more clarity.

Please let me know if it helps you.

 

Thanks

Tauqeer

Resources