Видео

❤❤❤❤❤

Very usefull video. Thank you for sharing. Used to write code with vb but if you don't use that staff regularly it's easily forgotten. It would be useful to provide the steps in creating the buttons. Also useful to hide the sheet automatically upon closing the file because if you save with the sheet unhiden it will be visible to anyone who opens the file next. Did some messing around with chatgpt which was unable to provide solid code for this to work after a couple of hours of trial and error. However, I copied a piece of code for hiding the sheet upon closing the file and added it to your code. Works with no issues.

Thank you, thank you, thank you so much. Life Saver. Million likes to you 😎😎🙏🙏

Thank you so much. It’s just awesome! 🙂

dengan rumus yang sama, di excel saya menampilkan eror, tidak berfungsi. ada yang bisa menjelaskan?

tnx

Just FYI. For this to work you need to save your Excel file as a macro-enabled file! Otherwise this won't work.

HI! IS THERE A WAY TO ADD SCREENTIP TO THE SHAPE THAT HAS ASSIGNED MACROS ALREADY?

I'm glad Bane took the time to show us this, very thoughtful of him.

macro file not available or disable, please guide

How can you keep undo button with macro

Awesome tutorial on querying a dataset with multiple criteria. I now realize that slicing and filtering are interchangeable in Excel, subsetting the dataset based on a criteria. Slicing is more effective for categorical fields, while filtering is more flexible allowing more logic operators (less than, great than, not igual, and, or,..., contains, between). Here is the interesting fact with alternative data analysis tools. With R and Python, slicing and filtering are approached differently. Now back to Filters in Excel, and inspired by another Teach Excel tutorial on filtering dates based on period, how intricate or hard could be to have a helper column (periods) with categories (this month, last month, this year, last year and YTD) and then insert a slicer. I mean approching the selection of period based on slicer, instead of a drop down list selection, filter(), helper setting with start, ends and vlookup().

Terima kasih.

I get a RunTime Error 9 Subscript out of range error with this code. Cant seem to make it work. My work still have Excel 2007 so...

Alt +enter

Bro! your voice is irritating its all base not sound lol

LOVE THIS! THANK YOU SO MUCH!

after the video, I subscribed

Excellent explanation. Thank you :)

Thank you for this.

What if I want the max value in the list for a product and not the value in the end of the list

2024 here! helped me a lot 😅

Thank you

Thanks you, helped me a lot 🙏 !!

Very helpful, just when I needed it. Many thanks!

brilliant - thank you for explaining this so clearly.. all the other videos make it so complicated

This worked perfectly! I see that you don’t do much in power query, but do you know how to do this in power query? My dataset is too big to have the formula in excel.

is there a way to do this for excel on macbook? I have tried installing this way but it does not work on my mac. It worked when i did it on a windows computer and it worked which is why i'm asking if there is another way to get it to work on macbook..

A lot of assumptions and pre-work to follow along making this less useful than advertised.

PERFECT! Thank you.

Thank You for the informative video. I would just like to know how we can transfer range of values. I tried inserting the range in the inverted commas, but it is taking only value of the 1'st mentioned cell. If anyone could please help me with it would be great help. Thanks Anyways :)

Very helpful video! Exactly what I needed. On a separate note, how can we automatically clear the dates if the data are deleted? When I delete the row of data corresponding to the dates, the dates don't disappear automatically, so I have to delete them individually. Could you make a video about this? Thank you!

best video

Brilliant video. I swear I have learnt more from Google and RUclips than school ever taught me :)

This is most wrost video ever....we can easily extract using text after and text before.

Please sir provide me

Thank you for the helpful video

makasih banyak Om !

Thank you

how about specific date?

what are the difference between aggregate and subtotal? seems look the same function as you illustrated.

Thank you , saved me bunch of time expanding those

Awesome tutorial, how to get the formula fully dynamic, by replacing the *G10* with a fórmula to return 1, 2, 3, ......

Thanks after 14 years!! It helps❤

It was interesting! Just started learning VBA for data analytics. Thank you!

table la eppadi =SEQUENCE(COUNTA(C:C)-1) varamattuthu

Thank you for this video! This was exactly what I was looking for. Have you found a workaround for the slicer timeline not having the feature for 'disable resizing and moving'?

This literally saved me at least an hour of work manually sifting through sheets. You are a life saver!

IT WAS THAT EASY???

Does all of the data import as text?