How to find missing numbers | MS Excel Tips & Tricks Tutorial
Join this channel to get access to perks:
/ @excelaz
This video shows you how to find missing numbers using sequence and unique functions in ms excel spreadsheet. If you like this trick, please comment.
Excel Tips & Tricks : • Intermediate Excel tip...
Excel Analysis : • Data analysis techniqu...
Excel Functions : • Excel important formul...
Excel DAX formulas : • Dax formula in excel |...
Excel for Job Interview : • Data cleaning in excel...
Excel 365 Features : • Excel new features 201...
Excel 2019 Features : • Playlist
Mobile Excel Tutorial : • Mobile Excel Tutorial ...
Creative & Advanced charts : • Creative & Advanced Ex...
Excel Automation : • VBA & Macro training i...
450 Excel functions with examples : • Learn 450 EXCEL FORMUL...
50+ Important excel functions with examples : • 50+ excel IMPORTANT FO...
Top 60 widely using most popular excel functions : • Top 60 MOST POPULAR ex...
Different types of MIS reports & dashboard creation : • MIS reports & Dashboar...
HR MIS dashboard using Power Pivot : • Headcount report in ex...
#excel
#exceltutorial
#msexcel
#microsoftexcel
#microsoftexceltutorial
#spreadsheet
#spreadsheettutorial
#learnexcel
#exceltips
#basicexcel
#advancedexcel
#exceltricks
#msexceltipsandtricks
#exceltutorialforbeginners
#excelforbeginners
Thank you for watching this video !!
Пікірлер: 33
Thanks.
@ExcelAZ
Жыл бұрын
You're welcome 🪔
Very easy! Thanks a lot
@ExcelAZ
3 ай бұрын
You're welcome!🥂
Loved it
@ExcelAZ
2 жыл бұрын
Wow that is great 💝
Just awesome
@ExcelAZ
Жыл бұрын
Thanks a lot 👍
Wow amazing trick
@ExcelAZ
2 жыл бұрын
👍
Very Nice ... Thanks
@ExcelAZ
Жыл бұрын
💝
ohhhhhhhhh super thanks
@ExcelAZ
Жыл бұрын
👍
Can this be used on any sequence of numbers? if my numbers start at 2513 for example? I have tried this but my numbers are starting from 1.
@ExcelAZ
Жыл бұрын
Yep. You can ⚡
@allinoneknowledge4574
Жыл бұрын
@@ExcelAZ how plz tell us
After the sequence formula, you can just check for duplicates and then filter by color
@ExcelAZ
4 күн бұрын
Wow! Thanks for the info! 🥂
I need this for my job and my excel doesn't support these commands as unique or sequence. I'm trying to find an another way.
@ExcelAZ
Жыл бұрын
If you have excel 365, then only you could use..
@omerhasan5343
Жыл бұрын
How can we find missing numbers on old excel ?
@ExcelAZ
Жыл бұрын
Which Excel version
@AdoBroTV
Жыл бұрын
Hello Excel (A-Z). I have one question, I have online version of excel that accepts these commands but it only works with small numbers (1, 2, 3...). I have 14 digits numbers,for example: 19257000050000 - 19257000100000. In this example we have 50000 numbers and I would need to find missing numbers between these ranges. Is that possible with excel? For me it doesn't work for some reason, it only works with small numbers.
@ExcelAZ
Жыл бұрын
I will make a video with big numbers..
mere excel me to sequence ka formula hi nahi le raha
@ExcelAZ
6 ай бұрын
Buy latest version
Can’t find the UNIQUE function
@ExcelAZ
Жыл бұрын
Latest version excel only has this function
@Jojosmith342
7 ай бұрын
why dont you mention in the video what excel version you are using to apply that formula. I follow the instruction and excel automatically close 3 brackerts at the end of formula. thanks@@ExcelAZ
@Jojosmith342
7 ай бұрын
what year is latest@@ExcelAZ
This video is BS, The UNIQUE command is used to list unique items contained within a list not list missing items. This trick video doesn't help anyone.
@ExcelAZ
Жыл бұрын
Experience is the best teacher 🧘