Assigning number based of value

sandlinfam

New Member
Joined
Oct 6, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,755
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Board!

Is this what you are looking for in cell F2:
Excel Formula:
=C2 & "-" & D2 & "-" & E2
 

sandlinfam

New Member
Joined
Oct 6, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,755
Office Version
  1. 365
Platform
  1. Windows
I think you mean "CONCATENATE". You could use that, or just use "&" like I did in my post.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,589
Messages
5,765,313
Members
425,272
Latest member
Umba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top