Star ratings chart -Excel
9:31
8 ай бұрын
Dynamically Combine tables Excel
14:49
CHECKBOXES-FILTER+XLOOKUP MAGIC
4:51
Пікірлер
@stanTrX
@stanTrX 3 күн бұрын
thanks. does it support html mail body?
@clkinfo
@clkinfo 4 күн бұрын
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.
@clkinfo
@clkinfo 4 күн бұрын
Very very very thankyou so much i find many way to do this but no one have good way!!!
@evanshearin6490
@evanshearin6490 4 күн бұрын
Thank you! This was so helpful!
@ibrahim82649
@ibrahim82649 7 күн бұрын
I tried this process but got an error on the first flow ( Launching outlook) the application has failed to launch outlook.
@ExcelMoments
@ExcelMoments 6 күн бұрын
Is Outlook properly set up on your PC, and can you launch it manually?
@ibrahim82649
@ibrahim82649 6 күн бұрын
@@ExcelMoments yes it is, actually I tried it this morning and it worked 🙂 as figured out how to include attachments 👍. Thanks for the tutorial
@ibrahim82649
@ibrahim82649 7 күн бұрын
This is a great tutorial, what if I had attachments for every recipient ?
@zidanmohiuddin1632
@zidanmohiuddin1632 7 күн бұрын
kalar baccha
@ExcelMoments
@ExcelMoments 6 күн бұрын
What does kalar bachha mean?
@Kevin-g3g1v
@Kevin-g3g1v 8 күн бұрын
SMART
@ExcelMoments
@ExcelMoments 7 күн бұрын
Thanks for the kind words
@simonec98
@simonec98 9 күн бұрын
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).
@pavanthakur5759
@pavanthakur5759 9 күн бұрын
How to do the same in Gsheet?
@ExcelMoments
@ExcelMoments 6 күн бұрын
I am no googlehseets expert but this should do it =MAP(A2:A9,B2:B9,LAMBDA(x,y,TEXTJOIN(", ",1,SORT(transpose(XLOOKUP(SPLIT(x," "),SPLIT(y," "),SPLIT(y," "),""))))))
@JorritScharloo
@JorritScharloo 11 күн бұрын
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.
@kaylendao9647
@kaylendao9647 11 күн бұрын
Thank you sir! This is exactly what I have been looking for!
@ExcelMoments
@ExcelMoments 11 күн бұрын
You are welcome ma'am
@mohamedsoffar4434
@mohamedsoffar4434 13 күн бұрын
Thank you for these 43 shorts playlist
@ExcelMoments
@ExcelMoments 6 күн бұрын
You are very much welcome
@Neoscarface6342
@Neoscarface6342 13 күн бұрын
Top g
@Woodpile63
@Woodpile63 16 күн бұрын
Thank you! I love simple tricks that accomplish difficult manual operations!
@ExcelMoments
@ExcelMoments 6 күн бұрын
So do I. You are welcome
@Shroomtomb
@Shroomtomb 18 күн бұрын
God send - thank you!
@ExcelMoments
@ExcelMoments 17 күн бұрын
@@Shroomtomb You are welcome
@tobiadekoya3774
@tobiadekoya3774 18 күн бұрын
Thank You. This is really helpful.
@ExcelMoments
@ExcelMoments 17 күн бұрын
@tobiadekoya3774 You are very welcome
@jinnellesiew1439
@jinnellesiew1439 19 күн бұрын
Save alot of my time .... thank you
@ExcelMoments
@ExcelMoments 6 күн бұрын
You are welcome
@EarlyLALY
@EarlyLALY 23 күн бұрын
Thank you so much sir!!!
@kadher_mh
@kadher_mh 27 күн бұрын
Is there a way to go back to the "Before" version?
@ClemenDK
@ClemenDK 28 күн бұрын
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
@H4XOR23
@H4XOR23 28 күн бұрын
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.
@Perun0001
@Perun0001 Ай бұрын
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.
@jazzista1967
@jazzista1967 Ай бұрын
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!
@ExcelMoments
@ExcelMoments Ай бұрын
Thanks Luis for the feedback. You know i love hyperlinks 😂
@christopherbenton4643
@christopherbenton4643 Ай бұрын
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!
@ExcelMoments
@ExcelMoments Ай бұрын
Thanka for subscribing and for the kind words. Glad you found it useful
@miladarastoueian2874
@miladarastoueian2874 Ай бұрын
Very Good
@ExcelMoments
@ExcelMoments Ай бұрын
@@miladarastoueian2874 Thank you
@stanleyroot9622
@stanleyroot9622 Ай бұрын
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.
@ExcelMoments
@ExcelMoments Ай бұрын
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
@claudiaayala9654
@claudiaayala9654 Ай бұрын
Absolutely brilliant thank you so much.
@ExcelMoments
@ExcelMoments Ай бұрын
You are welcome
@TejasRai-w8v
@TejasRai-w8v Ай бұрын
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?
@KinseiVenus
@KinseiVenus Ай бұрын
thanks LEGEND
@ExcelMoments
@ExcelMoments Ай бұрын
@@KinseiVenus you are welcome
@AronCassell-k8o
@AronCassell-k8o Ай бұрын
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.
@jazzista1967
@jazzista1967 Ай бұрын
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.
@ExcelMoments
@ExcelMoments Ай бұрын
@@jazzista1967 I wish i knew why it does not have a million views! 😀😀
@karandhiman4385
@karandhiman4385 Ай бұрын
How do we use delegated account if we want to?
@jazzista1967
@jazzista1967 Ай бұрын
Man... i miss your videos and your humor! HAHA!
@jazzista1967
@jazzista1967 Ай бұрын
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!
@ExcelMoments
@ExcelMoments Ай бұрын
Welcome back! Hopefully I can get back to video creation very soon
@jazzista1967
@jazzista1967 Ай бұрын
VIctor Good morning. Good to hear from you my friend. . Look foward to your new upcoming videos.... Take care and stay safe!
@liyanakanan
@liyanakanan Ай бұрын
thank you for the help!
@ExcelMoments
@ExcelMoments Ай бұрын
You are welcome
@santoshkoyada
@santoshkoyada 2 ай бұрын
Thank you.. It was really helpful
@crismurguia7140
@crismurguia7140 2 ай бұрын
So simple, yet never thoght about this solution. YOU ARE A GENIUS
@ExcelMoments
@ExcelMoments 2 ай бұрын
@@crismurguia7140 I will give the credit to Bob Umlas
@leerv.
@leerv. 2 ай бұрын
Ok that is pretty awesome! One more reason to love XLOOKUP() hahaha. Thank you!
@ExcelMoments
@ExcelMoments 2 ай бұрын
And many more reasons 😁😁
@Sup3r87
@Sup3r87 2 ай бұрын
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
@ExcelMoments 2 ай бұрын
What version of Excel do you use?
@Sup3r87
@Sup3r87 2 ай бұрын
@@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.
@ankursharma6157
@ankursharma6157 2 ай бұрын
Thank You!
@ExcelMoments
@ExcelMoments 2 ай бұрын
You are welcome
@sd647
@sd647 2 ай бұрын
legend
@ExcelMoments
@ExcelMoments 2 ай бұрын
Thanks so much
@luislozano4251
@luislozano4251 2 ай бұрын
Is there any way to add a blank row without number? For example 20 21 22 23 24
@ExcelMoments
@ExcelMoments 2 ай бұрын
when you say without number? I am not really sure what you mean
@luislozano4251
@luislozano4251 2 ай бұрын
@@ExcelMoments Every line has a number at the left, at the beginning The same for columns (letters) A B C D E F 1 2 3 4
@CullyCulls
@CullyCulls 2 ай бұрын
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"?
@ExcelMoments
@ExcelMoments Ай бұрын
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
@jhastie
@jhastie 2 ай бұрын
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.
@HarpreetGujral27
@HarpreetGujral27 2 ай бұрын
Can we do same through Power Automate Online? Actually, am unable to find similar step in online version.
@IvanCortinas_ES
@IvanCortinas_ES 2 ай бұрын
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.
@IvanCortinas_ES
@IvanCortinas_ES 2 ай бұрын
All the proposals are excellent. Thank you Victor.
@ExcelMoments
@ExcelMoments 2 ай бұрын
@@IvanCortinas_ES You are welcome
@lottieg4706
@lottieg4706 2 ай бұрын
Thank you for this.
@ExcelMoments
@ExcelMoments 2 ай бұрын
@@lottieg4706 you are welcome
@BigHatBoris
@BigHatBoris 2 ай бұрын
Blowing my mind mere seconds into the video. 🤯🤯🤯🤯🤯🤯🤯🤯