Hi All,
I have a master sheet where in Cell A9 is “Serial Number based on Cell B9 using the formula “=A9&TEXT(COUNTIF($A$9:A9,A9),"-0000000")
A 9
B 9
Vijay-0000001
Vijay
Rajiv-0000001
Rajiv
Suj-0000001
Suj
TK-0000001
TK
Vijay-0000002
Vijay
Rajiv-0000002
Rajiv
I have...