Forum Discussion
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...
Let's say the names begin in A2.
In B2, the initials: =IF(A2="","",LEFT(A2)&MID(A2,FIND(" ",A2)+1,1))
In C2, the sequence number: =IF(A2="","",COUNTIF(B$1:B2,B2))
In D2, the serial number: =IF(A2="","",B2&TEXT(C2,"00"))
Select B2:D2 and fill down as far as you want.
See the attached sample workbook.