วีดีโอ

Legend

Bravo!

tôi đến từ Việt Nam,rất vui vì những bài học thú vị

trên excel 365 của tôi không có các hàm này

Solve my problem!! Thank you

Thank you🎉 it solved my problem!!

I want my results to be the month in which the first order was delivered... anyone can hep with this formula please..

How can I get the result as the dates on which there is start of the number

Wow, you saved me hours of cut and paste!! Thank you!!

Greetings from my heartcore. Nice to have such video. Please let me know how I can do the same in excel file. Looking forward to hearing from you. Thanks in advance.

I just wanted my sheet easier to read. I forgot how to do formulas. I never use excel. I am now in my new job. I WILL JUST KEEP IT SIMPLE. Now I am gonna have to do excel class all over again😢.

Thank you uncle 🙌🏾

Great idea. This is a perfect work around to using a “slicer” in the filter function. I love this concept. Slicers are great but you can customize that selection section a million ways. Thank you for this great content. I will be integrating this into my projects for sure.

It is not working for me 😢

Thank you sir. You literally save my life.

We can't do that to a merged cell 🤨

thx

To build upon the formula shared in the video, I found a way to also ignore blanks and zeros in the ranking. Add an IF formula in front of it to return any zero or blanks found in the list of cells as blank. E.g. =IF($R$3:$R$42=0,"",XMATCH($R$3:$R$42,SORT(UNIQUE($R$3:$R$42),,-1)))

Awesome tutorial, concise, cristal clear!

Would it be possible to update a Excel file in a Teams group? I have a excel file that I have setup as a Teams interactive dashboard. All the users who can potentially run the VBA macro are members of the Teams group and have permission to work on the dashboard. I want to adapt it sio that when they run the script, when it is done, it then goes to the Teams group dashboard and then update when an action was complete.

BASED

Very nice...I am goint ro use this😊

thank you this is Brilliant!

When you will make more videos? waiting from long time

❤love u so much victor! your channel is pradise of wisdom!

Thank you it is very helpful 😊

thanks. does it support html mail body?

If i delete one the of sheet, then can delete the corresponding sheetname row data? e.g delete sheet "May", but at the sheetlist the "May" row have contain other data or information at column E, F, G.

Very very very thankyou so much i find many way to do this but no one have good way!!!

Thank you! This was so helpful!

I tried this process but got an error on the first flow ( Launching outlook) the application has failed to launch outlook.

This is a great tutorial, what if I had attachments for every recipient ?

kalar baccha

SMART

Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).

How to do the same in Gsheet?

Thank you, Victor, for demonstrating how to circumvent the limitations of textsplit. Finally found a solution to sum textjoined arrays (syntax 1|2|3/4|5|6 ) from certain rows within a table! I am very happy.

Thank you sir! This is exactly what I have been looking for!

Thank you for these 43 shorts playlist

Top g

Thank you! I love simple tricks that accomplish difficult manual operations!

God send - thank you!

Thank You. This is really helpful.

Save alot of my time .... thank you

Thank you so much sir!!!

Is there a way to go back to the "Before" version?

I have been sitting with multiple functions and lists, helper columns etc., and chatGPT as aid to no avail, and you basically solved the entirety of my project in one formula requireing only minor tweaks. Amazing, thank you so frikkin much dude <3 <3 <3

Hey I tried to implement it but it didn't work, can you please let me know your email? So I can give you spread sheet and you can send me one with macro in it I tried multiple times hence I'm thinking of sending you spreadsheet,so please let me know your email we'll communicate over there.

Saved my life! Thank you! If anyone is struggling just pause at 0:21 and don't use the + on the right side of your keyboard for me it didn't work, just the one on the top.

Victor... Great video.. not only your content is great but also your video production... Great tips on the Hyperlink function and that shortcut ALT left arrow to go back to your original cell. Thanks for posting!