Dec 13 2021 09:53 AM
Dec 13 2021 11:13 AM
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
Dec 13 2021 11:14 AM
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.