How to Use Excel IF Function to Generate ID Number | Dynamic Excel Serial and ID number: No VBA

preview_player
Показать описание

This ID or Serial number will be generating itself automatically every single time you enter a new name without having to type the ID or Serial number out yourself.

We are going to use IF Function, Isblank Function, Left Function, Excel upper Function, and Excel Concatenate Function to generate Excel Serial or ID number.

To make sure that our workbook is protected we are going to add excel security, which is Excel protection. We will protect the column with our Serial and ID number.

All we use to create this is excel functions.

SUBSCRIBE to follow along as I upload the whole STEP BY STEP TUTORIAL.

To create dynamic Inventory management or store management in excel (No VBA)

#iffunction #Excelfunction #excelserialnumber #exceldynamicid #excelprojectmanagement #excel #msexcel #exceldashboard #projectmanager #excelprojectmanager #excel
#kpiexcelpowerpivot
#exceldashboard
#howtocreateexceldashboard
#pivottable
#excelfunction
#excelsumproduct
#sumif
#sumifs
#excelanalysis
#msexcel
Рекомендации по теме
Комментарии
Автор

Hello Omeiza
You are amazing teacher
Thanks for your support

lukev
Автор

this is amazing for real it really help me at work to be honest from somalia 🇸🇴. this is so understandable wow. thanks buddy

iamzackyy__
Автор

Thank You so much, You have no idea how much it helped me .
THANKS ALOT

afreenwaseem
Автор

Thank you so much, Please, If I have a column of date (dd/mm/yy), how I can add the year to the ID?

raidanmaqtan
Автор

However, the audio quality is low, but I want to say Thank you so much Sir.... for sharing useful formula.

hsulliman
Автор

I am using another office suit and it keeps saying that I am using the wrong command in the first command.. it is WPS Office.. is it somehow different command format than real ecxel?

Toll
Автор

I need this but my columns can be sortered and thus always generates new ids. Which causes problems.

ChrisSorgeloos
Автор

I want excel to assign a unique number to each row and i want that number to NOT change if I sort my table or if I delete a row. In other words if I have 15 rows and I enter a 16th row I want Excel to auto name it serial number 16 and that serial number will stay with that row no matter if other rows are added or deleted and no mater how I sort those rows. How can I do that?

robh.
Автор

can you share the formula if we start on the first data? instead of putting number 1 can we have set-up a formula

kathyloria