🚀 FREE 50 Excel Hacks Template from Hubspot: clickhubspot.com/wcoo
@navaki333
17 сағат бұрын
This is the one that I was searching. Thanks for tge video for splitting data by using 3 methods. 1. Pivot filter, 2. Vstack + Filter formula and 3. VBA.
@onadipemayokun
Күн бұрын
Thank you so much Kenji.. I'm getting a syntax error on the code however, step 1 and 2 worked just fine😊
@markpodesta4605
Күн бұрын
Thank you Kenji!🙂
@KenjiExplains
17 сағат бұрын
Thanks for watching :)
@anjelas2708
16 сағат бұрын
Which version of Excel are you using? That message box while entering Q5 on the validated cell is quite modern looking. I am still getting an old school message box. I am on Excel 365 for enterprise.
@extraktAI
Күн бұрын
This is a great tip, thanks!
@KenjiExplains
17 сағат бұрын
Glad it was helpful!
@vedalamganesh9041
Күн бұрын
Hi Kenji, Your each video is very much helpful and intuitive.... Thanks for the content,,,, Could you tell me the software you use to edit your videos
@KenjiExplains
17 сағат бұрын
Thank you! we use adobe software
@schubertpeter79
Күн бұрын
awesome Kenji!
@KenjiExplains
Күн бұрын
Thank you!
@ogaemmatvchannel1837
Күн бұрын
Thank you sir
@KenjiExplains
Күн бұрын
Thank you for watching sir :)
@amitsalunkhe3489
18 сағат бұрын
Hi Kenji, How we can split data in workbooks instead of sheets and criteria will be multiple column header like sub-filter apart from main filter
@camlex6310
Күн бұрын
Great video!! Thanks
@KenjiExplains
17 сағат бұрын
Glad you liked it!
@govardhanreddy8233
Күн бұрын
I was looking for something similar solution for google sheets. Currently I’m using query with filter but working on appscript to automate it
@AmazingDiscountDeals
Күн бұрын
It is great. Thank you
@KenjiExplains
Күн бұрын
Thanks for watching!
@pluto_dp
Күн бұрын
It would be also nice to know how to do the opposite. I mean, starting from multiple sheets, aggregate data that present common columns. Maybe you have a video for that already?
@KenjiExplains
17 сағат бұрын
Yes I do here actually: kzitem.info/news/bejne/wJuay22bbqN1fII
@pluto_dp
14 сағат бұрын
@@KenjiExplains TY Kenji 🙏🏻
@harshmudliar3737
Күн бұрын
I am looking for something that's the exact opposite of this. I need to combine different Workbooks into one. its customers data. I have tried Power Query, but faced issues with managing the same customer having entries in different months.
@akritigoel9497
Күн бұрын
May be you should try consolidate if I am not wrong
@mirash7
23 сағат бұрын
Can you explain your problem with some additional details? I think in case you have some header problems, you can demote the headers of each page and then append all of them into a new query and then use that query.
@pistonssssss
4 сағат бұрын
All different data set must be converted to tables and must have at least one common column. Create coonection between them, than make a pivot from any of them, but mark “Add this data to data model”…
Пікірлер: 31