Automatic Numbering

Hi everybody. Is it possible to make an automatic numbering system (should be in sequence), with prefix at the start of the number depending on the choices?

Prefix are as follows-
COMMERCIAL = 01
MEDICARE = 02
MED PDP = 03
GENERAL = 04

for example:
if i choose COMMERCIAL in B2 it should return me with a value of 01-001 in A2
if i choose MEDICARE in B3 it should return me with a value of 02-001 in A3
if i choose MED PDP in B4 it should return me with a value of 03-001 in A4
if i choose GENERAL in B5 it should return me with a value of 04-001 in A5

But if i choose again COMMERCIAL in B6, it will give me a value of 01-002 A6
and same with the others.

List should be dynamic, meaning i could change any inputs in cell B:B and their corresponding values in cell A:A will change also

Pls see picture attached for reference, the outcome should be the same but i want the numbers to be automatically generated.

Is this possible? any help will be appreciated.. plssss..
Thanks

assuming your data is starting from B2 and going down then in A2 you can try below
=TEXT(IF(COUNTIF($B$2:$B2,B2)=1,ROW(A1),MATCH(B2,$B$2:B2,0)),"00")&"-"&TEXT(COUNTIF($B$2:B2,B2),"000")

can you please let me know where it is not working accordingly

find attached

Something like Hemesh

in that case use below in
A2 and drag down

Formula:

Please Login or Register  to view this content.

Here E1 to E4 are
commercial
medicare
med pop
general

you are welcome and thanks for feeback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.