Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848

[@heartofmadrid216]

The only guy that deserves a like in youtube . Thank you brother .

[@excelisfun]

You are welcome, Brother Of Fun Excel!!!!!!

[@Softwaretrain]

Thanks Mike, Nothing more efficient to add. GroupBy is my favourite.

[@excelisfun]

Thanks, Teammate!!!!!!

[@JeffreyLiu-k9d]

daily dose of truth in data management

[@excelisfun]

: ) : ) : )

[@johnborg5419]

Thanks Mike. Groupby is amazing!!

[@excelisfun]

Microsoft is so good to us : )

[@vishal.pandey2001]

Finally , a video to satisfactorily end my day The all new excel function made it a lot interesting to move forward but you never fail to give a comparison Thank you so much for the videos

[@excelisfun]

You are so welcome for the videos!!!!

[@Prosperity-hk8ub]

Mike, Thank you for another magic boost!!

[@excelisfun]

You are welcome!!!!

[@SyedMuzammilMahasanShahi]

Thanks Amazing Mike for this EXCELlent video.

[@excelisfun]

Glad you like it, Fellow Teacher!!!!

[@HusseinKorish]

Amazing comparison ... thanks Mike

[@excelisfun]

You are welcome, Hussein!!!!

[@gvitullib]

Group By for this; great emt Mike. Thanks!

[@excelisfun]

You are welcome : ) : )

[@nsanch0181]

Thank you for showing the several methods for counting. Countifs was easy enough I just wish the criteria syntax did not require the ""& at the = operators because that always gets me. =COUNTIFS(D3:D590,G10:G21,E3:E590,"

[@excelisfun]

SUMIF, COUNTIF, COUNTIFS, SUMIFS and the like have been like that since the beginning. We just have to get used to it : )

[@richardhay645]

GROUPBY easy winner. However I always use PIVOTBY even when I could get by with GROUPBY. I started that practice after the second time I decided later to add columns to the mix!!

[@excelisfun]

I love it: GROUPBY easy winner : ) : ) : )

[@roywilson9580]

Thanks for another great video, Mike!

[@excelisfun]

You are welcome, Roy!!!

[@roywilson9580]

@@excelisfun You are welcome, sir! I hope that your mom is getting better.

[@excelisfun]

@@roywilson9580 , She passed away and is in a better place. I am still dealing with her estate and aftermath for a while to come.

[@roywilson9580]

@@excelisfun I am very sorry to hear that, Mike. My sincerest condolences on your sad loss.

[@MalinaC]

Thank you for this magic trick and 👍!!! 🙂

[@excelisfun]

Thank you Teammate Malina : ) : )

[@azizurrehman6296]

Hello Mike Hopefully you will be fine...God Bless you along life..

[@excelisfun]

Thank you for the kind wishes!!!!

[@nadermounir8228]

Thank u Mike for this great Video 📹 👍

[@excelisfun]

You are welcome, Nader : ) : )

[@chrism9037]

Thanks MIke!!! I still don't have GROUPBY in my MS 365, and I'm on the Insider channel. Can't wait to get it

[@excelisfun]

I can't wait for you to get it either. Come on Microsoft, speed it up!!!!!!!!!!!!!

[@brianxyz]

I finally got it and PIVOTBY a few weeks ago. Which version are you on? I got it as of Version 2402.

[@ubaidillahmuhammad20]

Thanks mike..just correction the last EMT 1850

[@excelisfun]

Yah... lol... I posted the EMTs out of order. I posted 1847, 1850, 1848 and next week will be 1849

[@roderickmose4691]

We can all still COUNT on Mike to deliver!

[@excelisfun]

Thanks for the COUNT : ) : )

[@abdelazizallam]

Thanks : ) : ) i hope the groupby function get in excel 365 soon it is in insider to now

[@excelisfun]

I hope so too : ) : )

[@rehanshah2091]

Is there any way, power query load data from online drives "folder", without any sign-in. In onedrive, we need to give access to other people to the folder. Couldn't find google drive folder access in power query.

[@excelisfun]

I have no idea. I don't think that is allowed for security.

[@rehanshah2091]

@@excelisfun When we use folder in onedrive from browser link (till layout)..power query consider all files from all folders and creating query with base folders doesn't work for other people even if we give them access to specific folder we are using..do we have method to get data from onedrive folder and share so that other can use when we give them access to the onedrive folder.

[@UtuDudas]

I am looking forward to the release of groupby and pivotby

[@excelisfun]

It will change a lot : ) Microsoft is very good to us!!

[@UtuDudas]

@@excelisfun I was trying to do a count with criteria inside a large Let formula, and Countif/s can't do it

[@azizurrehman6296]

I have learned Excel,PBI from your channels and now My level is upgraded...but I have Query maybe you can make a video on that...I have a PBI dashboard and I want to get some data from that visuals maybe in 4 excel files . and I want to put these 4 files in a folder then I have another files which is called a Merge files on which I have merge these 4 files data in 4 different sheet...I don't know what are the methods I can use to do this..maybe PowerAutomate , or directly from excel to import data from that PBI visual.

[@ExcelInstructor]

Hi Mike! How are you? Could I take you on your promise from some time ago? Could I ask for a shout out in some future episode? Also, it does not have to be a table - it can be named range as well :)

[@excelisfun]

Yes, of course. I am still taking care of my Mom's estate after her passing. Until about April, 2024, I am making videos only one time a month. I have a video already recorded that will be out next week. So next time and make videos, I will give a shout out. You should send an email to me at excelisfun at gmail - to remind me that I should do this : )

[@williamarthur4801]

Hmm , any month now, but which year?

[@GM085]

Byrow and sumproduct works too. =byrow(G10:G21,lambda(r,sumproduct(D3:D590=r,E3:E590

[@excelisfun]

Wow!!! New School and Old School : ) : ) : )

[@richardhay645]

1:12 How does that make things easier? AND defeates the ETA-LAMDA capabilities of BYROWS as well as GROUPBY??