Sometimes you need to create a unique code for a list of products, or Students or patients or any other work situation.
In this tutorial, I teach you how to create a Unique Alphanumeric code with a predictable pattern that takes its structure from your data, while being sequential without any duplicates. Adding more records to the source results in automatically generating the new codes. Having a unique identifier for each record is very important in Excel, In Access, in Data Modeling and in Power BI.
I am using Microsoft 365 with Excel Dynamic Array Functions.
This tutorial is not just intended to show you “How To Create An Alphanumeric Code” but rather to teach you the “Art of Creating a Single Cell Report” and build the logic of complex functions, like a charm!
You can read the Step by Step instructions and Download the Exercise file to follow along, by clicking on the link:
[ Ссылка ]
So, let’s see how to do that in Excel.
For Corporate Training with Nabil Mourad, check:
[ Ссылка ]
To become a Microsoft Office Specialist, check:
[ Ссылка ]
