thank you Master Mike for another fantastic short trick on filter function. In fact, appreciate your systematic free videos and excel/power bi files for me to start appreciate the technology
You taught me excel in 2014 and I always love how you always emphasize on shortcuts. I am always seen as an expert in the office because of those shortcuts. 😀. Many thanks
Thanks Mike. Its amazing how new excel functions have helped to shorten a formula with less complications. Although the old school was fun to build too. :) :)
Hi Mike hope you are well and that your mom is on the mend. Another great video! So much easier than the old school version; it is strange to think there are competent excel users out there that have never and will never know the brain ache caused by such intricate formulae, or the absolute headache of debugging them! I look forward to the next in the series.
@excelisfun I just reviewed this video "FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842". Thanks for it! I've been learning Filter function. My question is can you take what you have done with this video and create multiple tables below each other that filters the main table for you which allows to add or delete rows as needed for each new table and not spill into the next table? Been going crazy trying to figure out if this is possible. Thanks!
Thank you very much Mike! As always, a nicely delivered lesson 😀 . I wonder if there is a way to extract every sub table dynamically using array formulas? I've seen this done using Power Query but I'm interested if the new array formulas can do the trick. Best Regards.
To further expand my question: what I imagine is a Master Table but arranged by criteria and adding a subtotal for each sub table. It would be nice if after every subtotal there is a blank row. Thanks!
I notice in many of your videos, you are working with standard ranges and not tables, just curious if that is your preference and if so why. I always go back and forth with should I make this data set a table or not and the ease use with formulas between both.
In analysis I use Excel Tables almost 100% of the time. Dynamic is the only way to go. But with teaching videos, when you use ranges within an Excel Table that are not full columns or tables, the visual look of the table formula nomenclature is horrible and makings things more confusing. The trick to good teaching is story telling. And the trick to good story telling is to have no extraneous elements in the story. Every detail matters. If there is a detail that does not help deliver message, you must remove it. I love Excel Tables, but sometimes they mess up the story.
@@excelisfun thanks so much for the reply and completely understand. Really appreciate all you do, I’ve basically exclusively learned most of the things I know in excel from you, so thanks a bunch.
@@excelisfun funny enough it was only yesterday I was doing some unique / no blanks without resorting to FILTER just try and keep hand in and it made my head hurt. we getting spoiled.
The college servers are down. They are trying to bring the servers back up, but it has been difficult. The servers will be back up, but we are not sure when.
Hi Mike, How Are you? I could not find an email to you. Is it ok for me to aks for a shoutout? Or is it somehow wrong and evil to ask such things? Im not sure about the etiquette here, Im sorry of im overstepping.
Great video!!
These old formulas should have collectable value !! Like an old 930 Porsche 911 Turbo 😊✌
I love the 911. Always wanted one when I was a kid : ) : ) : )
thank you Master Mike for another fantastic short trick on filter function. In fact, appreciate your systematic free videos and excel/power bi files for me to start appreciate the technology
You are welcome!!!
You taught me excel in 2014 and I always love how you always emphasize on shortcuts. I am always seen as an expert in the office because of those shortcuts. 😀. Many thanks
That is THE truth. Keyboards wow everyone at work!!!!!! Many you are welcomes!!!
Gracias Mike, por esta nueva entrega. Yo espero que todo este muy bien de tu lado. Un abrazo fuerte hasta la distancia. Saludos.
: ) : ) : )
Old school way was a masterpiece at that time ... Thanks Mike
Yes it was : ) : ) : )
what a phenomenal function that is SO EASY.
M365 does make it easy for us : ) : )
Thanks Mike. It's always easy to understand your methodology. Thanks for sharing...
You are welcome for the methodology and share!!!
Thanks Mike! Thank God we got the Microsoft 365 functions. That old formula looks painful!
There is a beauty to the pain, but thank god for M365 : )
Filter is awesome! Thanks Mike.
You are welcome, Luciano!!!!!!
Excellent! Thank you for another masterpiece demonstration in teaching!
You are welcome for the fun : )
Thanks Mike. Its amazing how new excel functions have helped to shorten a formula with less complications. Although the old school was fun to build too. :) :)
You are welcome, Formula Guy John!!!!
Nice showing the whole process.
Whole process is always more fun : ) : )
Northing to say mike, Just amazing of Filter function. Thanks a lot.
You are welcome a lot!!!!
Back to basic RAD Mike !! but oh boy minute 2:28.... the good old school ways! Never to be forgotten.
Superb Mike, Filter Is so versatile
FILTER is one of the greatest new function Microsoft has given us : ) : )
Hi Mike hope you are well and that your mom is on the mend.
Another great video! So much easier than the old school version; it is strange to think there are competent excel users out there that have never and will never know the brain ache caused by such intricate formulae, or the absolute headache of debugging them!
I look forward to the next in the series.
That is a keen insight: competent Excelers without the historical intricacies, logical beauty and headaches!
Still taking care of Mom in CA.
@@excelisfun I wish you both well
Hey Mike. Welcome back. Hope your mom is doing better now
I am still taking care of Mom, but I am trying to still pop out a few vids : ) : )
Excellent !!! Very Very excellent !!!
Glad you like the EXCELlence ; )
Thank u Mike for this great video 📹 👍
You are welcome, Nader!!!!!
Wow Excellent Mike
Glad it is EXCELlent for you ; )
Hopefully one day Microsoft will give us smart spilled formatting.
Would be nice!!!!
Des Monis? lol. Glad to see something never change. Thanks for the video Mike. Just need a few more subscribers to make the 1M.
Never changed since I was born: canent spelle lol
yes! One function to rule them All!
Filter for the win.
Superb Video:) Mike,
How is your mother doing?
Goal, Homerun, Touchdown for FILTER!!!! P.S. My Mom is still in bad shape, but I am still in California helping my Mom every day : )
@@excelisfun all the best for you both! a lot of health for both of you. Hope for the best.
very useful video sir, thanks .
hope your mom is fine now.
Thanks Mike. Its amazing
You are welcome, Abdelaziz!!!!!
@excelisfun I just reviewed this video "FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842". Thanks for it! I've been learning Filter function. My question is can you take what you have done with this video and create multiple tables below each other that filters the main table for you which allows to add or delete rows as needed for each new table and not spill into the next table? Been going crazy trying to figure out if this is possible. Thanks!
nothing but thumbs up!
Glad you like it!!!
Fantastic!!!!
Thank you very much Mike! As always, a nicely delivered lesson 😀 . I wonder if there is a way to extract every sub table dynamically using array formulas? I've seen this done using Power Query but I'm interested if the new array formulas can do the trick. Best Regards.
To further expand my question: what I imagine is a Master Table but arranged by criteria and adding a subtotal for each sub table. It would be nice if after every subtotal there is a blank row. Thanks!
I notice in many of your videos, you are working with standard ranges and not tables, just curious if that is your preference and if so why. I always go back and forth with should I make this data set a table or not and the ease use with formulas between both.
In analysis I use Excel Tables almost 100% of the time. Dynamic is the only way to go. But with teaching videos, when you use ranges within an Excel Table that are not full columns or tables, the visual look of the table formula nomenclature is horrible and makings things more confusing. The trick to good teaching is story telling. And the trick to good story telling is to have no extraneous elements in the story. Every detail matters. If there is a detail that does not help deliver message, you must remove it. I love Excel Tables, but sometimes they mess up the story.
@@excelisfun thanks so much for the reply and completely understand. Really appreciate all you do, I’ve basically exclusively learned most of the things I know in excel from you, so thanks a bunch.
Hey mike, do you have any tutorial video about how to make table automatically?
Now my to do list for tomorrow, watch 538, which I don't think I've seen.
Love it!!!! A bit of history on the list today : ) : ) : )
@@excelisfun funny enough it was only yesterday I was doing some unique / no blanks without resorting to FILTER just try and keep hand in and it made my head hurt.
we getting spoiled.
@@williamarthur4801, I am like you: when I create a formula using M365 functions, I almost always remind myself of the old way too : )
Hey there, the links to download the worksheets in your Excel basics video are not working. Kindly look into it.
The college servers are down. They are trying to bring the servers back up, but it has been difficult. The servers will be back up, but we are not sure when.
Hi Mike,
How Are you?
I could not find an email to you.
Is it ok for me to aks for a shoutout? Or is it somehow wrong and evil to ask such things?
Im not sure about the etiquette here,
Im sorry of im overstepping.
Yes, you can ask. But I am down taking care of Mom and do not have eqipment to make videos right now.
@@excelisfun I fully understand 100% :)
Taking care of family member is top priority :)
Thank you for responding and willingness to help out :)