New Excel Functions: Master GROUPBY and PIVOTBY with Real-World Examples
Вставка
- Опубліковано 21 січ 2024
- #excelformula #excel365 #excelfunctions
Hello Friends,
In this video, we have explained how to use new Excel function GROUPBY and PIVOTBY with real world example.
Below is the link to download the practice file:
www.pk-anexcelexpert.com/mast...
Subscribe our new UA-cam Channel:
/ @neotechnavigators
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
Firstly, thank you so much for all the valuable teachings.
Consider: =GROUPBY(HSTACK(Country,Segment),Sales,HSTACK(COUNTA,SUM)). The COUNT inside HSTACK simply does the counting of "Sales" What I really want it to do, is to count "Segment" That way, I will know that there are 20 Channel P in Canada. This having used =GROUPBY(HSTACK(Country,Segment),Segment,COUNTA).
Great Video Bro..
Thanks for watching
Thanks for the share.
Most Welcome
The possibility of using more than one function (with HSTACK) is the key here. It didn't work when I done it last week, but I'll give it another try! Thx
Thanks a lot for useful video.
Most welcome
Thank you so much, Sir.
You are most welcome
Great video and you explain very well..
Glad it was helpful!
Very nice! Thanks!
Our pleasure!
Sir, I have a problem with search data from multiple sheet with details, how to do please make a video on this topic with detail I shall be thankful to you love from Pakistan . I am your regular youtube viewer.
Please watch below video for search data form multiple sheets:
ua-cam.com/video/vWEabzCbtzc/v-deo.html
Very well explaind sir, but i've a doubt if country in B colmn and Product in F or may be any other column except C, then how do we get the data in row field country and product both?????
Great! I cannot download the file. Is it somewhere else? Thank you
Check now
Hello sir muj aap ka utility tool chya to mil sak ta hai kya Protact na hoi aasi file ?
How to active this. Not available in my office 365 sir.
These functions are currently in Insider Beta version. Will be available soon for all Excel 365 users.
Aap ka koi payd course hai sirji ?
Will create soon
groupby option not working in my excel sheet sir ,Please
It is in beta version as of now. will be available soon for all Microsoft 365 users.
I noticed one thing , if you are using multiple columns , then you should use them from Left to right , you cannot use selective column , also selecting columns from Right to left does not properly works...
I m not findin in excel 365
मेरे पास office 365 है मगर ये function नहीं है तो केसे ये function लाए
You will get soon. Microsoft is rolling out gradually
How u use it
This channel is not for beginners
How to use griup by function between 2 dates