Summarize data EASILY with the GROUPBY function in Excel!

preview_player
Показать описание
This new function is a huge deal and will massively simplify what used to involve some quite complex LAMBDA functions.

This is the first in a new mini series on the functions newly announced in November 2023.

#data #excel #exceltips
Рекомендации по теме
Комментарии
Автор

What if you use VSTACK(YearColHeader, YEAR(YearColDatabody)) for the first argument on that? I don't have Groupby yet so i can't test it out.

mdismailhosen
Автор

Spectacular. The definitive end of pivot tables. Thank you!!!

IvanCortinas_ES
Автор

Great Tutorial 👏 So many Insights in just 9mins 🙌

BhavyaGupta
Автор

Awesome as always. Thanks for sharing, Owen!

elbadlis
Автор

Absolutely blown away by the content of this video. This video will standout in videos on Excel. Thank you sir 🙏

chakralamurali
Автор

Thanks for sharing!
I wish the excel formula bar of yours in the video could be more clear or zoomed...

sunnybaggu
Автор

Perfect 👍 please share data file for practice

usmaniqbal