A place for all levels of Microsoft Excel users to brush up on their skills. Sometimes the videos may be on not frequently used functions, some "mysterious" Excel feature or very basic concepts, but at the end of the day, you are learning, picking up new skills and being more productive at work. Victor Momoh
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.
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!
You are the best! Got a new subscriber off of this one. I wish I would've found your video sooner, watched 30 plus minutes of other videos over explaining things and describing multiple scenarios. You were concise & I appreciate your help!
Brilliant, clear explanation. Fully agree with previous comment!! - you change my life with this tutorial. love u so mach man!!! Why on earth excel hasn't turned this into a standard function for such a common question, is beyond me.
Absolutely agree with you. With LAMBDAS, you can create your function that does this exactly, but I am with you totally, a native function will not be bad
Is there any possibility to write a VBA code to automate persons availability check (time slots) using outlook scheduling assistant like checking free/busy or by any other method?
Great video thanks, got it working for what I was looking for. I do have one question at 3:36 for example you add the array and get F3# all i get it a fixed A1:A6 for example I assume I am missing something.
Why this video only has less than a thousand views? It should have more than 10 or 100's thousands of views. This is a brilliant approach of on overcoming the limitation of the textsplit function when working with 2 arrays at the same time. Thanks again Victor.
Victor... how are you doing? I started to watch more of your short videos... i have not seen you posting much content lately.. i will catch up with your regex examples today. I hope you are doing well. Take care!
Hmm, in excel for me "find and select" is a much smaller menu and there is no "go to special". When I press ctrl+G I also get a "go to" window with no "special" button and again with a different appearance. Seems like Microsoft removed the feature - very annoying.
@@ExcelMoments I use the web version through Microsoft 365 - I ended up "solving" the issue by deleting the entire array and re-inserting a new one, then making the modifications I wanted to again lol.
You just saved me hours of manual labor, thank you! Quick question, is there an object I could add to the vba script that would identify if the comment thread is "resolved"?
Apologies for my late response You can do something like this ws.CommentsThreaded.Item(I).Resolved, it would return a Boolean (True/False) depending on whether the thread had been resolved or not
Thank you SO much for this. I did not realize that the key was to also include the change in the Currency tab. Hallelujah!! I can't believe I finally have a solution to this, and it's thanks to your video. I've also told ChatGPT to include that in its explanation to users.
It is absolutely essential to have a thorough understanding of how these functions work. Many of the problems we face are data modeling problems and these functions solve these difficulties. Thank you for the explanation.
This is close to what I'm trying to do. I have an Excel sheet with a list of appointments I want to mass import into my Outlook calendar as appointments, while not importing duplicates. The Excel sheet has the subject, location, start date, start time, end time, and description in the appropriate columns named as expected.
@ExcelMoments - How to send a single Teams Meeting to all those listed in excel column A that are required and all those listed in excel column B as optional? I've tried maneuvering the code several times but can't seem to get it. Any help would be appreciated. Thank you!