How to Find Missing Numbers in Excel Using Dynamic Functions

Optional tip if this was helpful: paypal.me/LouisDeconinck
Learn how to find missing numbers in Excel using functions such as UNIQUE, SEQUENCE and VSTACK in a dynamic and automatic way.

[@KlinAprimora]

Hey, Louis! Have you tried the Microsoft Excel World Championship? This video of yours is a perfect example of the situations we face there within the 30 min challenges!

[@LouisDeconinck]

Thank you for the suggestion. I've watched the championship in the past, but never thought about participating. Perhaps I should give it a shot ... How does it work?

[@fssacko]

Great thank you lot Mister Louis

[@LouisDeconinck]

Glad you found it helpful!

[@unnikrishnansanthosh]

simply super, thank you for sharing

[@LouisDeconinck]

My pleasure, just combining some functions in a clever way.

[@steventezcan689]

Great content ! thank you Louis,

[@LouisDeconinck]

My pleasure!

[@ExcelInstructor]

at the end, you could also add Lambda function and pass the range to it, so you wont have manualy resize it everytime

[@LouisDeconinck]

Thank you for the suggestion, that would indeed be an upgrade for this function.

[@akulakarter6949]

Nice.
Thanks 🙏

[@LouisDeconinck]

So nice of you!

[@BalvirSingh-qs9kz]

सर, isme two numbers more bar aaya इसको आपने नहीं बताया कि यह दो बार

[@ragulmarley4900]

😮data set link

[@LouisDeconinck]

What do you mean?