Note: all the custom functions you see used in this video are LAMBDA functions. No VBA UDFs used. So the resulting formulas all work equally well in Excel 365 on Macs and Excel Online as they do in Windows. If there are any LAMBDAs that you are particularly interested in, let me know here in the comments and I can make them available as Gists.
00:00 - great intro Erik! 03:10 - great pro tip: Active sheet back up, especially when working with macros. 05:40 - Paste Apply Left Join.... WHAT????? insane...woah!!! 06:55 - Generate Lambda statmente...who?? wow.....bravo! 09:15 - Ok, how much for Paste Exact Formula? (mind-blown) To continue watching it tomorrow!
ปีที่แล้ว
10:55 - a Lambda for Wrap with Index of Min by Row? 😮 17:35 - simply speechless...(mind-blown), loving how you are addressing the problem or tackling it with your approach. 25:10 - 👏👏👏👏👏👏👏👏 amazing! wuaoo!
Thanks! If you are interested in understanding microautomations, I recently spoke at the Toronto MS Excel Meetup on this topic: th-cam.com/video/_zJ9a-n2MVA/w-d-xo.html
@@sunnybaggu785 magical, I love that, thank you! I originally created this tool for myself because I suck at keyboard shortcuts but now I’m working hard to make it available to the public. It is as fun to use as it looks.
@@excelrobot request you to share more of your content in TH-cam and LinkedIn, so that people like me can learn more from your teachings. Best wishes 🌻
Note: all the custom functions you see used in this video are LAMBDA functions. No VBA UDFs used. So the resulting formulas all work equally well in Excel 365 on Macs and Excel Online as they do in Windows. If there are any LAMBDAs that you are particularly interested in, let me know here in the comments and I can make them available as Gists.
YES! The intro - was amazing Erik 🔥😁👌
The more I see of the Robot the more I like!
00:00 - great intro Erik!
03:10 - great pro tip: Active sheet back up, especially when working with macros.
05:40 - Paste Apply Left Join.... WHAT????? insane...woah!!!
06:55 - Generate Lambda statmente...who?? wow.....bravo!
09:15 - Ok, how much for Paste Exact Formula? (mind-blown)
To continue watching it tomorrow!
10:55 - a Lambda for Wrap with Index of Min by Row? 😮
17:35 - simply speechless...(mind-blown), loving how you are addressing the problem or tackling it with your approach.
25:10 - 👏👏👏👏👏👏👏👏 amazing! wuaoo!
This is cool. I would be keen to try it in an Excel competition.
a BIG 👍from this channel. Erik = genius !!!
I have no idea what this is, but it probably took a lot of time to put this together. Thanks for uploading lol :)
OK, back here. Popcorn ready, as well as the Doritos, to enjoy and learn. 🔥🔍👀
I don't know what I just saw but it looks awesome.
Thanks! If you are interested in understanding microautomations, I recently spoke at the Toronto MS Excel Meetup on this topic: th-cam.com/video/_zJ9a-n2MVA/w-d-xo.html
That's really exciting...can't wait to learn these....can you please share how was that possible....magical..
Thank you
@@sunnybaggu785 magical, I love that, thank you! I originally created this tool for myself because I suck at keyboard shortcuts but now I’m working hard to make it available to the public. It is as fun to use as it looks.
@@excelrobot request you to share more of your content in TH-cam and LinkedIn, so that people like me can learn more from your teachings. Best wishes 🌻
Would love to beta test but I'm not smart or nerdy enough I can tell! Awesome video! Subscribed! Liked!