Видео

Thanks so much for this video. First of all when you’re typing your code, how are you getting the list of options to pick. For example when you type the “.” It shows you a list of VBA Code to pick like .Subject. Second of all what’s the code to set a meeting to “Private”.

Thank you , great solution also the explanation behind it made me understand the concept also

That is why I am subscribed to this channel Mr. Momo! Thanks!

Thank you - nice walkthrough!

Can it be done if one of the tables has one column less, and can all the other tables be adjusted to show only the columns based on the table that has fewer columns? I want to vstack these tables, assuming they all have the same header. Thank you for this case and solution, it is extremely helpful and illustrative.

Thanks Victor! 👍

My Excel does not have Fix Trailing in Text to Columns. Is there a way to revert to a version that has that?

Thank you Victor. Xlookup is King. Vlookup also works but may be a bit clumsy: VLOOKUP($B$4,LET(a,DATE(1,SEQUENCE(12),1),b,SEQUENCE(12),HSTACK(b,TEXT(a,"mmmm"))),2,0)

Great solution once again Victor, thank you

fantastic

Hi Victor Momoh, I hope this message finds you well. I recently came across this video and wanted to express my appreciation for your excellent content. Your knowledge and expertise in Power Automate and Excel are truly impressive and have been very helpful to me. However, while following the steps in this video, I encountered an issue where the flow stops automatically and throws an error on some files. Upon checking the pattern, I observed that the files throwing the error are those with a hyperlink as the name of the worksheet. I was hoping you could assist me in troubleshooting this issue. Thank you in advance for your help, and keep up the fantastic work! Best regards, Sumeet Katariya

nice and amazing

Best explanation of REGEX so far Victor, thanks

I like this. You're the first to get me to sit down and give REGEX a try.

That’s impressive! Especially the Regex formula in Google Sheets!

Couldn't wait to use it. That's a fun one. Nice 1 Victor.

Nice little trick Victor, thanks for sharing

Very cool 😊 Thanks Victor!

Interesting method Victor. Thanks for being so creative.

CELL function didn't cross my mind. I have always used ADDRESS with ROW and COLUMN functions to get it. Awesome 👍

Great video and method! Thank you for creating/sharing this Victor! I use this trick all the time but I have not done a video on it yet so I am going to share yours and include a link to it when I discuss my use case in my video.

Nice trick!

mind-blowing Victor! woah! --- 👉🤯

I do understand reduce function generally but not here

one of the best easy formula, thanks!

Excellent !!

Awesome as always!

Thanks for the video, very interesting. Is it possible to create the hyperlink column and its formula in PowerQuery before loading the data into excel ?

Excellent!

As always Victor, very elegant resolution. "Small bricks" joined together creating a "large building". Thank you!!

Great technique, Victor. Thank you. I was going to advice an additional check for presence/absence of trailing slash in the path (a user can put it or vise versa). But you solved this possible scenario by an elegant macro of folder selecting. Thumbs up 👍

Unbelievable, one of the most useful excel tips i've watched. Thank you so much.

This is sooooo smart! Okay I am subscribing. Thank you sooo muuch!!!!!!!!!!!!!

Thanks!

Thank you for the great video. So, how can you turn this Monospace Font feature on and off again?

Really happy to have found this channel! Your step-by-step explanations are so clear and easy to understand. Looking forward to working through the past and future challenges!

Hi victor thanks for the video Just a question How can we dynamically change both the find and replace value in find and replace step instead of directly mentioning in the flow Like I want to change both the find and replace value dynamically My use case I have separate file where all the masters are captured in an array like Column A column B chocolate | dark bars Cookies | biscuits Soft drinks | beverage I want to check this file take column A value(cookies) as find value and replace it with corresponding column B value(biscuits) in all my files then take second value soft drinks etc till my master comes to an end Would really appreciate if you could assist me in the solution.

You just saved me hours of work, thanks!

Espectacular !!!

Worked perfectly, thank you

Thank you

Love that Base function! Hadn't seen it before. Just went in a rabbit hole learning what it does and what it's used for. Fascinating! Thanks for sharing.

Thank you so much for your help!! Also another note is that, if it still seems to be not working. Try closing excel and reopen. Or go to regional setting, set to United Kingdom or US which works for me. Appreciate it again!

You come up with Excellent content and explain things very well, Victor! This channel deserves a LOT more subscribers.

Thanks Victor, brilliant formula 👍👏 A few years ago I created a formula (for a specific day) as a joke using the BASE function: =TEXTJOIN(" ",,BASE({17998221;26345872;17242},36))

Excellent

Thank you so much ❤️

Thank you so much, Victor. Can you help me check why this approach doesn't work? =SORTBY(TEXTSPLIT(A2,", "),COLUMN(TEXTSPLIT(A2,", ")),-1) I have done it differently but it's not working when I write the formula together. I'm just trying to understand these formulars better. Thank you and well done.

MAY 20, 2024 New Regular expression (Regex) functions in Excel