Assigning number based of value

[sandlinfam]

Hello to all. I am attempting to create a serial number system for my job. I am able to auto assign numbers but that is not what I am looking at doing. I want to be able to have excel differentiate between one item from another and automatically populate that serial. Example bellow

Let’s say:
C2 = ICS
D2= MAT
E2= 0001

I want F2 to auto populate: ICS-MAT-0001.
Every time “MAT” is entered, that is auto assigns like above even if “Cell” D2 changes value. I need the value of column “D” to show up as its own run of serial numbers. Example:

ICS-MAT-0001
ICS-BAR-0001
ICS-MAT-0002
ICS-MAT-0003
ICS-BAR-0002
ICS-MAT-0004

 

[Joe4]

Welcome to the Board!

Is this what you are looking for in cell F2:

=C2 & "-" & D2 & "-" & E2

 

[sandlinfam]

Thank you joe! Would I be using the command =countif; or =constatenate. At my sons game will play with it when I get home. Thank you!

 

[Joe4]

I think you mean "CONCATENATE". You could use that, or just use "&" like I did in my post.