Create SKU Categorys

[AlphaDawg2004LJ]

Hey Guys,
I'm creating a very large budget for 2022 and using the 2021 budget as a starting point for an IT group. I want to create unique SKU's for the existing budgeting items so we can easily manage to the new budget next year and to track spend YoY. I have created 2 digit category's based upon the description of service. I would like to now create unique sequential values along with that category to track items in my budget. I can do a simple sort and Countif function but would like to be able to use the SKU format I listed below. Thanks in advance for any assistance.

Category	Description	SKU
SW	Web Services	SW0001
SW	Trace	SW0002
SW	Cloud Servers	SW0003
SW	Mobile Platform	SW0004
TU	Hosting	TU0001
TU	Anomaly Detection	TU0002
PF	Enterprise - External	PF0001
PF	Enterprise MFA	PF0002
PF	Premier - Prod	PF0003
PF	Enterprise - Prod	PF0004
GA	Travel	GA0001

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1	Category	Description	SKU
2	SW	Web Services	SW0001
3	SW	Trace	SW0002
4	SW	Cloud Servers	SW0003
5	SW	Mobile Platform	SW0004
6	TU	Hosting	TU0001
7	TU	Anomaly Detection	TU0002
8	PF	Enterprise - External	PF0001
9	PF	Enterprise MFA	PF0002
10	PF	Premier - Prod	PF0003
11	PF	Enterprise - Prod	PF0004
12	GA	Travel	GA0001
Lists

Cell Formulas
Range	Formula
C2:C12	C2	=A2&TEXT(COUNTIFS(A$2:A2,A2),"0000")

 

[AlphaDawg2004LJ]

That worked perfect. Thanks for the help.

 

[Fluff]

You're welcome & thanks for the feedback.