Every time I learn something about Excel the more I realize it’s just the world’s most painful coding environment
@marymotherofgod4861
6 ай бұрын
Same ugh😮😮😮😮😮😮
@jimg4059
6 ай бұрын
Honestly, I’m a power user, and you’ve taught me a few really interesting applications for various formulas that have legit helped my workflow. Thanks dog!
@NoName-NoGimmicks
Жыл бұрын
The first second of an Easy Sheets video is equal to the euphoric anticipation of hearing about a great movie from your friends then the day comes when you see it yourself. Never knew watching an Excel Master would be simultaneously jaw-dropping and awe-inspiring.
@farzinjahed9575
Жыл бұрын
He is rapidly becoming my favorite KZitem shorts channel. He is always teaching something useful.
@bigt6928
Жыл бұрын
This will be so helpful! Thank You for this information!😊
@YoucefYoucef-ft9ce
Жыл бұрын
I'm an accountant I'm using this method all time. Thank you for your efforts. Youcef from Manhattan
@Ginupop
Жыл бұрын
While I didn't learn it from this video the Vstack Filter combo is great, and you can easily use it on files stored in a different networked drive. Saved my bacon! The more people who know, the better!
@cruzinsweetsntreats
Жыл бұрын
It's also faster in loading, than using Power Query to bring it in as a table. Especially coming from multiple workbooks.
@cruzinsweetsntreats
Жыл бұрын
With the Insider Beta, VSTACK & HSTACK load on Excel for Android.
@ravitejaa5672
Жыл бұрын
Excellent💯👍
@Stevencyw88
7 ай бұрын
Great sharing. This is super useful
@mikemcculley
Жыл бұрын
The original sin was splitting the data across the sheets in the first place.
@Viazm
Жыл бұрын
Yes but sometimes it depends fom others
@dallasgirl3470
Жыл бұрын
It's necessary sometimes
@alexc.2783
Жыл бұрын
This is it! This is the thing I needed for the last 3 years for my budget sheets! Dude, I'm subscribed!
@ManasMadrecha
Жыл бұрын
Filtering empty rows was cool
@misterwill3625
Жыл бұрын
It was 👏🏾
@melaD333
Жыл бұрын
Brilliant.. going to try this today!!
@marcus2259
Жыл бұрын
Helpful when you want to edit a specific sheet without scrolling for too long.
@CodexEvans
Жыл бұрын
Dark Master, the supplicant kneels to absorb more of your wisdom!
@budisutrisno2083
Жыл бұрын
Useful. I have sheets with same format but i know nothing to combine them into one sheet. Thank you for showing this technique. It's cool bro...
@johnathanhunter9359
Жыл бұрын
Bro I just got an accounting internship where I do reconciliations in excel everyday. I have never subscribed to a channel faster!
@leowu1644
Жыл бұрын
Public accounting?
@FadhilBasery
Жыл бұрын
Very useful! I collect and record monthly data, this is really helpful to make yearly summary. Thank you! 😊
@thebluelord_25
9 ай бұрын
At this point, this guy's gonna run Doom in Excel soon.
@alexwhitehead2186
Жыл бұрын
Just used this..... worked a treat!! thanks so much
@akumaten
Жыл бұрын
I like that dynamic aspects
@croskoal
Жыл бұрын
Great tip. I've never seen this formula before, and it looks amazingly useful
@misterwill3625
Жыл бұрын
Another awesome, informative video. 👏🏾 There’s been times when this would’ve helped. This is why I follow you. I’m sure this will come up again at work
@ayna4641
8 ай бұрын
Nice❤
@bigbaby91
Жыл бұрын
Data > Get Data > From Tables > once all loaded > Append Queries as new
@Boomk27
Жыл бұрын
This is what I’d do too.
@sassouusasoo3607
10 ай бұрын
Most people don’t know about power query .
@fauzibaharumify
10 ай бұрын
Using power query right?
@easy_sheets
9 ай бұрын
Power query is amazing
@arunkt8184
7 ай бұрын
@@easy_sheets Pls do the video about Power query.
@publiusii4246
Жыл бұрын
I don't know what I did to have Google decide I needed useful excel tricks in my shorts but I'm commenting so the algorithm keeps doing it
@nordborn9706
Жыл бұрын
Great stuff. Straight to the point. ❤
@aliwaqar3720
11 ай бұрын
Nicee👍🏻
@mayajanaka
9 ай бұрын
All the videos so useful 🎉🎉🎉🎉 thank you so much 🙏
@shugotenchi
Жыл бұрын
I can almost HEAR my work PC melting down into unbelievably radioactive butterscotch crunch processing 500,000x11 volatile cell values.
@fdm2155
Жыл бұрын
I don't even use Excel very much but this is amazing.
@jamesclark2020
Жыл бұрын
Beautiful.
@kHoPhAe
Жыл бұрын
Do you know you’ve made me a genius at work? 😂
@Soundwave1of9
Жыл бұрын
Very good! Thank you
@petersibanda5218
8 ай бұрын
Great!
@dauskamaruddin3272
10 ай бұрын
thanks for the information..
@rawat3668
Жыл бұрын
superb
@umesh2403
Жыл бұрын
This was what I was looking for ages..since when is it available?
@aashishshrestha1252
Жыл бұрын
Cool😊
@user-ht5ce2it3z
Жыл бұрын
I don't even use Excel anymore and these fascinating me for some reason.
@mightypiratethreepwood
Жыл бұрын
Top! Thank you!
@YRSHAHI
8 ай бұрын
Great
@brianzibricky
Жыл бұрын
I never though Brad Pitt could provide such excellent Excel tips, but here we are.
@makhosazanasibeko9666
9 ай бұрын
I've wanted this function, thanks
@bhaggoporiksha2940
Жыл бұрын
Great..Thank U Good Samaritan❤.
@no-damn-alias
8 ай бұрын
Thank you.
@grinfacelaxu
11 ай бұрын
Nice
@mzinzin
Жыл бұрын
Love it
@aSpyIntheHaus
10 ай бұрын
Gold!
@homelander2768
Жыл бұрын
Easy decision! Subscribed
@melaD333
Жыл бұрын
Tried this but couldn’t get the filter portion to work but it still works great because I’m using a pivot table as well. Exactly what I needed. Thank you!!
@ahsanfareed354
Жыл бұрын
Thank you so much ❤
@rempitizm
Жыл бұрын
Thank you, great tool.
@nosuchthing8
Жыл бұрын
Wow
@sachavez100
Жыл бұрын
This is handy.
@cihanseraykut518
Жыл бұрын
Omg!! thank you
@Selenzell
Жыл бұрын
İ have been trying to do something like this for quite some time and i couldnt figüre out how. Thanks a lot ❤
@ewnetuawraris6858
Жыл бұрын
Thanks Dude! Problem Solved
@mtn66amassuonoobpawa35
Жыл бұрын
You know you're getting older when your fyp recomands you exel tips...
@clubley2
Жыл бұрын
Would this not work without the filter if you just format the tables as tables? This is the second video I've seen from this channel, both are using undefined tables where formatting as a table would reduce the complexity.
@verygoodboy2688
Жыл бұрын
Neat but im just gonna filter by blank and delete those rows. Much easier and cleaner than nesting functions
@bakchormeeman7864
9 ай бұрын
Copy and pasting does the exact same thing but is so much less complicated.. I mean.. this just feels like you’ve made your life harder for no reason at all
@ScottMattes
Жыл бұрын
Would be nice if the version of excel vstack is in would be mentioned
@chedisLoL
Жыл бұрын
Up to date. Usually O365. If you can’t pull up the date when the function is added (which takes the same amount of time as your comment) then dont even comment.
@ScottMattes
Жыл бұрын
@@chedisLoL why not, the goal of putting these videos out is to be helpful so that info would be helpful - a great many people still work at places that don't use the latest and greatest
@cruzinsweetsntreats
Жыл бұрын
Referencing the version, such as Insiders Beta of Office 365 is a caveat, as not everyone has it. Though there is a free tool to upgrade.
@ariarc
9 ай бұрын
All these new functions are so time saving, recently I finally decided to get the 365 subscription. It's turned out to be cheaper than buying the physical software only for it to be outdated in a couple of months.
@ZyadSV
Жыл бұрын
I hope when I need to add data like this to remember this way, but I'm sure I won’t
@GordonSux
Жыл бұрын
This shit is genius.
@cruzinsweetsntreats
Жыл бұрын
HSTACK allows you to bring in split columns
@John-jt3dn
Жыл бұрын
you can do thid by using filter in { ... } also
@Zinkyness
9 ай бұрын
I really need to take an excel course, lol.
@easy_sheets
9 ай бұрын
I'm about to release one!
@garmo1968
Жыл бұрын
If the data on the other sheets are formatted as table then you don't need the extra space by dynamically targeting the table column it'll grow automatically Also instead of filter try using sort instead it would dump your empties to the bottom of the list
@911Salvage
Жыл бұрын
Dumping blank rows is more preferable most of the time.
@garmo1968
Жыл бұрын
@@911Salvage I agree I prefer finding ways to avoid including them to begin with most
@sadaqitali5703
Жыл бұрын
nice
@BeerTrooper
Жыл бұрын
Is this also working in the Office 365?
@WorldSeriesBound
9 ай бұрын
My brain ploded
@marcins5235
Жыл бұрын
Thnx
@Whiskeyj456
Жыл бұрын
A few months ago I got sick of having to export csv’s from a vendor for daily reporting at my job and having to append them together. Found out we have api integration with that vendor and decided to learn SQL. Wrote a query for it and now I just have an auto refreshable dashboard in power bi, saving me a ton of time each day. Only downfall? I’m now the “data” guy for my department and busier than all hell.
@John-li1df
Жыл бұрын
Why need the extra space. ?
@Blee48
7 ай бұрын
Turn all tabs to a table source. Merge all on power query. Done... No formula needed
@Zer0Gravity31
Жыл бұрын
Queries work a little better for an easier data appendage
@ANunes06
Жыл бұрын
I've shat on some other tips, but this is actual real shit. =FILTER(VSTACK()) is based.
@fauzibaharumify
10 ай бұрын
What about using power query to combine all excel tabs?
@alializadeh8195
Жыл бұрын
thanx
@phylectures2023
Жыл бұрын
Hi, just like this, is there any option to sum all the similar data on multiple sheets to a single master sheet?? (In Google sheets?)
@getdatmoneymane9930
9 ай бұрын
Like bro what???? How do i even know this Btw this channel was literally my fastest sub
@mechtist
Жыл бұрын
damn, i wrote a macro to do this a few days ago lol! it's only 9 (necessary) lines of vba.
@olmasbeksharipov2963
Жыл бұрын
You can do this with power query
@michaelwinter742
Жыл бұрын
Make your range B2:E
@arielbene2013
3 ай бұрын
please help i can only stack using commas .. i cant choose multiple sheets and multiple cells
@Ir._Fan
8 ай бұрын
Why would i add those extra sells for the first place. If i didn't add any extra sell, there wont be any empty sells, isn’t it like this?
@shoddits2156
Жыл бұрын
you should mention that this function only available to excel for microsoft 365
@HarshMelon
Жыл бұрын
You use this with tables so you don't have to do the filter?
@goodvibes4144
Жыл бұрын
In my excel sheet this formula now showing so, now what I have to do!?
@pabspurba
Жыл бұрын
How about the reverse version?
@albacan
Жыл бұрын
Its time to enable verbal instructions
@jaydnbaker1127
Жыл бұрын
Now, how do you do that with multiple excel documents?
@youcifebraheem8510
7 ай бұрын
or by Power Query🎉
@brendanroberts4866
Жыл бұрын
i hope one day I need to use this ! orthat when I do, I can find this video
@maxkp361
Жыл бұрын
I don't have the filter formula why that?
@blowave313
Жыл бұрын
What's VSTACK function in french please ?
@kevalvichare4759
Жыл бұрын
Hello sir , How to convert xlsx file into pdf version
Пікірлер: 156