Excel How to Create a Unique ID or Primary Key Using IF Function

How to Create a Unique ID or Primary Key Using IF and ROW Functions | Excel Tagalog Tutorial

Nowadays, creating a unique ID or primary key in Excel is relatively easy if you know how to use the Query editor or PowerQuery in Excel. However, if your current version does not support this or you don't have an idea on how to do this, you may find yourself thinking of doing this using a formula.

In this video, you will learn how to create your own primary key using the combination of several functions primarily the IF and ROW functions.

There are several formats that you can choose from to suit your requirement.

1. Incrementing number
Ex. 1, 2, 3, 4 etc.
2. Incrementing primary key (formatted as "000")
Ex. 001, 002, 003 etc.
3. Student number which is based on year and semester joined
Ex. 2020-1-000001, 2020-1-000002, 2020-1-000003 etc.
4. Varying client id depends on the destination
Ex. CAN001, CAN002, NEW001, NEW002, AUS001 etc.

To learn how you can apply this, please watch the video.

Download Practice File
https://drive.google.com/file/d/16Mf3...

“Ultimately what you do is secondary. But how you do it is primary.”
Eckhart Tolle

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combi...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert


"To EXCEL in the workplace, one must know how to use excel!"
Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy