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
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
best explanation of lambda as well.
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)
Loved it!
Thank you!!
Perfect! Would it be able to do the distinct count by Pivotby or Groupby?Could you please advise?
I show that in the video! 😃 have a watch again!
is it possible to apply different functions to each value?
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
@@learnspreadsheets possible. with hstack for valuesand function. i saw it on another video and tried, it works
Wow great news sir
Game changing!!
where i foun this group by function in Excel? i could not find in office 365
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
excellent :) will it be possible to format total rows etc. (rows will change position if data is added)
Hi you can put sub totals at top or bottom, & if new rows get added to the data the totals move automatically!
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
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
@@learnspreadsheets okay. thank you very much for the update. I panıcked for a sec ))
I dont have them either!!! Even if im in the beta channel! We have to be patient 🥹
Dear David,
I really liked the video, but I was sad because the function is giving an error in my PT-BR version. 😒🤗
Thanks, oh no sorry to hear, report it to Microsoft! It’s probably a bug that will be fixed soon
@@learnspreadsheets Pivotby causes workbook crashes
Great
Game changing!!!
what's the date that it will be available for all?
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
Why in my excel not showing in this function, i am using Excel 365
It’s beta channel only. I mention this in the last 20s, how to check which channel you’re on
Thank you
Thanks for sharing, David. Can anyone download a beta version?