AlphaDawg2004LJ

New Member
Joined
Oct 15, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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.
CategoryDescriptionSKU
SWWeb ServicesSW0001
SWTraceSW0002
SWCloud ServersSW0003
SWMobile PlatformSW0004
TUHostingTU0001
TUAnomaly DetectionTU0002
PFEnterprise - ExternalPF0001
PFEnterprise MFAPF0002
PFPremier - ProdPF0003
PFEnterprise - ProdPF0004
GATravelGA0001
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
How about
+Fluff 1.xlsm
ABC
1CategoryDescriptionSKU
2SWWeb ServicesSW0001
3SWTraceSW0002
4SWCloud ServersSW0003
5SWMobile PlatformSW0004
6TUHostingTU0001
7TUAnomaly DetectionTU0002
8PFEnterprise - ExternalPF0001
9PFEnterprise MFAPF0002
10PFPremier - ProdPF0003
11PFEnterprise - ProdPF0004
12GATravelGA0001
Lists
Cell Formulas
RangeFormula
C2:C12C2=A2&TEXT(COUNTIFS(A$2:A2,A2),"0000")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,141,062
Messages
5,704,055
Members
421,325
Latest member
tapete86

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