Great video Mike. I learn something new everytime I watch any of your videos 😃
@excelisfun
4 жыл бұрын
Glad there is new for you, Nader : )
@CornerMeetJZ
4 жыл бұрын
Thanks Mike. It also works: =UNIQUE(FILTER(G9:G48,Match(F9:F48,MODE.MULT(F9:F48),0)))
@excelisfun
4 жыл бұрын
I could not get it to work. It gives NA.
@kiwikiow
4 жыл бұрын
Microsoft 365 + Mike = Amazing Tutorial. Thank you 😀
@excelisfun
4 жыл бұрын
You are welcome, kiwikiow!!!
@mattschoular8844
4 жыл бұрын
Thanks Mike. Your demo makes me appreciate my Office 365 subscription even more.
@excelisfun
4 жыл бұрын
It just keeps getting better and better. I had extract modes the other day and I went to do it the way and then said, wait, Microsoft 365 Excel just makes it soooooo much easier : ) Everyday we just keep doing our normal stuff and the new way is just so exacting! A whole new frontier of radness!!
@myau3591
2 жыл бұрын
Thank you. Really save my day.
@IvanCortinas_ES
4 жыл бұрын
The behavior of the MATCHX function is very interesting. Thanks Mike for this great video!
So much easier and more amazing than how we have done it for the last decade... Agreed, Edge : )
@edge5817
4 жыл бұрын
@@excelisfun You really make Excel more fun Mike! I love Excel because of what I have learned from you Mike! More Power Mike!
@darrylmorgan
4 жыл бұрын
Boom!Wicked Formulas.Microsoft 365 Simply Getting More And More Awesome...Thank You Mike :)
@excelisfun
4 жыл бұрын
Thanks for your BOOM , darryl : )
@johnborg5419
4 жыл бұрын
Thanks Mike. It's 5:41 AM here.......What a great way to start!!!! it charges my Batteries in Excel Mode for the rest of the Day!! : ) : )
@excelisfun
4 жыл бұрын
Yes!!!! Batteries charged : )
@nsanch0181
4 жыл бұрын
Thank you Mike for the MODE tricks. Looking up the exact matches in a list using XMATCH(G9:G48,G9:G48) was also neat. Thank you.
@barttitulaerexcelbart9400
4 жыл бұрын
Thanks Mike. Very interesting to see the difference with the new 365 version. I also tried the PQ solution: Group by, countrows.... Great job Mike!
@excelisfun
4 жыл бұрын
Yes, PQ to the rescue : )
@darshanchudasama1565
Жыл бұрын
Great Video, helped me so much! Keep up the great work
@chrism9037
4 жыл бұрын
Outstanding Mike!
@excelisfun
4 жыл бұрын
Glad you like it, Chris : ) : ) : )
@BillSzysz1
4 жыл бұрын
Many thanks !!!
@ashoksahu9546
4 жыл бұрын
Great Great Great video. You are a genius.
@excelisfun
4 жыл бұрын
Glad you like the great, great, great video : )
@gokulkrish8868
4 жыл бұрын
Thanks sir from India 😊😊😊
@excelisfun
4 жыл бұрын
You are welcome!!!
@pmsocho
4 жыл бұрын
Thumbs up!
@GeertDelmulle
4 жыл бұрын
Once you go MS 365, you never go back,... :-) Great Dynamic Array formulas, BTW, especially the second one. Also, like others have said: I just might be inclined to go the PQ-M route on this one, but as always: your formula solution is the best! :-)
@GeertDelmulle
4 жыл бұрын
Took MS long enough, though. But that’s in the past now. :-)
@excelisfun
4 жыл бұрын
Each tool has it benefits: PivotTable for when the PivotTable can do it and you don't mind refresh, Worksheet Formula when you need instant update and PQ, when you get external data or PQ does something that nothing else can do quite as easily : ) General guidelines : ) : ) : )
@excelisfun
4 жыл бұрын
Never go back ... : ) : ) : ) : )
@excelisfun
4 жыл бұрын
@@GeertDelmulle Right!?!?! Way too long enough...
@wayneedmondson1065
4 жыл бұрын
Hi Mike.. thanks for the MODE Monday fun! Thumbs up!!
@excelisfun
4 жыл бұрын
MMF is always good : ) : ) : )
@OakleyTurvey
4 жыл бұрын
Fantastic Microsoft 365. How did we cope before it? False economy for Excel users now NOT to have the latest version with all these wonderful, time-saving features.
@excelisfun
4 жыл бұрын
AND, Oakley, we are only getting started. It just makes everything 100 times easier. I do not know how we coped before...
@vida1719
4 жыл бұрын
A wonderful way to explore survey results. For those, who do not have Microsoft 365, but at least have personal One Drive account, you can move Excel files to one Drive and open from there. Dynamic arrays formulas will be available.
@excelisfun
4 жыл бұрын
Wow!!! That is a hot tip!!!!!! One Drive to view Excel Solutions : ) :) Thanks Teammate Vida : )
@gunsl1ng3rflaco
3 жыл бұрын
Thanks this is great, but what if I was looking for the top two values? Not just when they are tied? Also can the answer spill over horizontally instead of vertically?
@HusseinKorish
4 жыл бұрын
This's great ...thanks Mike
@excelisfun
4 жыл бұрын
You are welcome, Hussein : )
@nabilan6150
4 жыл бұрын
Thank you so much, it was so fun to watch this and learn. I'm seeking an accounting major, wich one of your playlists do you recommend to start with, knowing that I have a very basic knowledge of Excel??
@excelisfun
4 жыл бұрын
My accounting playlist is here: kzitem.info/door/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ- However, The Excel Basics class is the best starting place for all Excel users: kzitem.info/door/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
@nabilan6150
4 жыл бұрын
@@excelisfun Thank you Sir! I'm starting with the Excel basics. The first video I watched was amazing. I appreciate your work, can't thank you enough.
@mohamedchakroun4973
4 жыл бұрын
I think the office 365 is putting the fifth speed with dynamic arrays and x dfunctions thanks mikeee
@ashishmohan4707
4 жыл бұрын
Hi Mike Hope you are doing fine. How ia your health. Very useful video and very practical need everyone for every project ......very big thanks to share with us. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
@excelisfun
4 жыл бұрын
Yes, sir, happy to help our Team : ) : ) : ) : )
@AdvanceOffice
4 жыл бұрын
very informative video sir , good one :)
@excelisfun
4 жыл бұрын
Glad it is mode-erific for you, A O : )
@AdvanceOffice
4 жыл бұрын
@@excelisfun i will surely try :)
@sherryizzie5309
4 жыл бұрын
Awesome trick, Mike! To return the text in Microsoft 365, I would prefer to use Xlook instead:) XLOOKUP(MODE.MULT(F9:F48),F9:F48,G9:G48)
@excelisfun
4 жыл бұрын
Yes, that is good, sherry : ) But it requires the number column which is usually not there when we have text data : )
@TheDirge69
4 жыл бұрын
If I have spreadsheets using the old formulas is it worth changing them to the new versions?
@excelisfun
4 жыл бұрын
If you are going to share them with others that do not have Microsoft 365, then you probably do not want to change yet.
@simfinso858
4 жыл бұрын
Nice.
@excelisfun
4 жыл бұрын
Glad you like ti, SIMFINSO!!!
@patrickschardt7724
4 жыл бұрын
Awesome stuff. I see another way. Not sure if it’s faster or not. Find the numerical rank modes. Then use those as the lookup values, use the category key number column as the lookup array, and the category key text column as the return array of XLOOKUP. For the 365 version of your formula, LET would be handy and speed up the calculation
@excelisfun
4 жыл бұрын
Cool! Thanks : )
@VS-rh8rq
4 жыл бұрын
Great
@excelisfun
4 жыл бұрын
Glad it is mode great for you, Vimal : )
@azazgaanja5728
2 жыл бұрын
how to make a list with most repeating number, second most, third most.... so on...??
Пікірлер: 64