PivotTables but better, using new Excel function: GROUPBY PIVOTBY

[@dougmphilly]

best explanation of lambda as well.

[@learnspreadsheets]

Glad you liked it! I have another longer video on lambda too (but honestly I feel google sheets implemented named functions in a better way)

[@thebhaskarjoshi]

Loved it!

[@learnspreadsheets]

Thank you!!

[@nigilv.d4237]

Wow great news sir

[@learnspreadsheets]

Game changing!!

[@nkn108]

is it possible to apply different functions to each value?

[@learnspreadsheets]

It’s not possible with groupby nor is it possible with pivot tables, you can do separate calca with sumifs countifs if you want that

[@nkn108]

@@learnspreadsheets possible. with hstack for valuesand function. i saw it on another video and tried, it works

[@adbapatla940]

where i foun this group by function in Excel? i could not find in office 365

[@learnspreadsheets]

Hi, it’s only released for the beta channel for now. That’s indicated on the thumbnail, description & in the video itself, it’ll come to the other channels soon

[@Kriya40]

Perfect! Would it be able to do the distinct count by Pivotby or Groupby?Could you please advise?

[@learnspreadsheets]

I show that in the video! 😃 have a watch again!

[@romany4all]

Great

[@learnspreadsheets]

Game changing!!!

[@JoseAntonioMorato]

Dear David,
I really liked the video, but I was sad because the function is giving an error in my PT-BR version. 😒🤗

[@learnspreadsheets]

Thanks, oh no sorry to hear, report it to Microsoft! It’s probably a bug that will be fixed soon

[@patricklonski]

@@learnspreadsheets Pivotby causes workbook crashes

[@sørenf-l6s]

excellent :) will it be possible to format total rows etc. (rows will change position if data is added)

[@learnspreadsheets]

Hi you can put sub totals at top or bottom, & if new rows get added to the data the totals move automatically!

[@OrkunAkar]

I updated my excel 365 and I stıll cannot see these new functions such as groupby pivotby ... Does any one know how to resolve this issue? thanks

[@learnspreadsheets]

It’s only been rolled out to the Beta channel for now, hence I have “beta” on the thumbnail & I explain that in the last 20 seconds of the video. It’s also not yet available to all beta users but will be soon

[@OrkunAkar]

@@learnspreadsheets okay. thank you very much for the update. I panıcked for a sec ))

[@PiggyBankAccountantFR]

I dont have them either!!! Even if im in the beta channel! We have to be patient 🥹

[@darkavenger100]

what's the date that it will be available for all?

[@learnspreadsheets]

I can’t know, Microsoft take things out of Beta a while after, so it could be 3 months or a year, unlikely more I would say

[@shadow_gaming_sk]

Why in my excel not showing in this function, i am using Excel 365

[@learnspreadsheets]

It’s beta channel only. I mention this in the last 20s, how to check which channel you’re on

[@shadow_gaming_sk]

Thank you

[@agnesc4768]

Thanks for sharing, David. Can anyone download a beta version?