Require Unique Code from counta formula.

Dear Sir,
I have applied this formula to get the unique code.There is a correct result everywhere but where the result is coming 8 and 9 from counta formula or where the result is coming 98 and 99 from counta formula.he is coming result wrong,i want total 6 digit unique code from this formula.

also i attached the sheet.
pls suggest if you want to apply some different formula.
kindly help me..
Thank you.
=A&LEFT(C2,1)&IF(COUNTA($C$1:$C2,C2)>999,"",IF(COUNTA($C$1:$C2,C2)>99,"0",IF(COUNTA($C$1:$C2,C2)>9,"00","000")))&COUNTA($C$1:$C2)-1


FORMULA-2-001 (1).jpg

in the coulmn i , i want to result First Character is "A" and second character is First Charactor of Main District and after series No. continues increment.

fisrt charactor of main district "S" of SOLAPUR DISTRICT "L" OF LATUR DISTRICT "O" OF OSMANABAD DISTRICT.

enclosed herewith sample file..

Originally Posted by Glenn Kennedy

Your explanation was not at all clear. So a guess:

="A"&LEFT(C2,1)&TEXT(ROWS($A$2:A2),"0000")

If incorrect upload a small sheet with EXPECTED ANSWERS, not a formula thta does not work.

Sir, This is correct , its my mistake.

Thank you Sir.. perfect result ..