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

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

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

SUBSCRIBE NOW:

YouTube Playlist:

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

[chaelboleche]

IF skills lang meron ako eh ahahahaha . pinapagana ko nalang sa =SUM . iba ka talaga sir Romeo Costillas . Student niyo po ako dati .

[flowerlane]

THANK YOU SO MUCH.

Took me 2 days to figure out a good way to do this and your way is the best way to make sure duplicates are avoided.

[Rmcinco]

Grabe, ang hirap talaga nito, matuto din ako for sure 👍!

[CaptainBochog]

thanks sa video.... laking tulong bro...

[cilkambal]

very helpful, thanks for this tutorial

[danielmadsen]

This is a great video, thank you so much!
But I can't help but wonder if I were to sort by names or something it would mix up previous references?
Since it doesn't lock to the content of the row but instead to the row itself.

[ruwansri]

How to break the formula and move into the next row? "In fomula typing bar"

[mustafasalihates]

You already notice that final column wasn't primary lol