Excel Challenge: Expand grouped Intervals -Reduce Function
HTML-код
- Опубликовано: 16 июл 2024
- Expand grouped intervals in Excel is at the heart of this challenge. The reduce function is key to making the solution work.
00:00 Introduction
00:19 problem statement
00:46 Visualizing the problem
01:43 TEXTSPLIT & helper functions
04:14 Brief overview of REDUCE function
08:00 Solution in one cell
12:40 Extending Solution using MAP
13:34 Concluding thoughts
docs.google.com/spreadsheets/...
Origin = You don't understand the process.
Victor Momoh appears and applies logic using functions in Excel.
Result = You understand the process.
Thank you for another explanation gift.
hahaha, I ove this breakdown 😁😁 Thanks for the feedback and kind words
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!
That is why I am subscribed to this channel Mr. Momo! Thanks!
@@ohdjrp4 Thanks
I love how well-structured this video is, building up a complex formula with easy-to-follow intuitive steps all the way up to the implementation of the MAP. Educationally and didactically so useful.
Thanks for the feedback on the video. I could not have written it better
Another master explanation! Thank you
Thank you for the feedback
Lovely solution! I have not used MAP or REDUCE much so far, so that was really useful. Thanks Victor
MAP is much easier to use. It simply takes a transformation or calculation, and it applies same to every element in the Array. REDUCE takes a little getting used to
Hellooo Victor!!!! Excellent video and GREAT EXPLANATION as always. Before i see your solution, i stop the video and i say to myself: Ok, he needs to do some kind of split and somehow use the sequence function to generate a list of numbers etc. But then i say HOW is he going to use those pieces of information? Then, I play the full video and digest your solution. I will be playing this video a few more times (Maybe 10 more times) to understand the entire solution.
The beauty of the video is the construct of the sequence using the MIN and the MAX minus one putting it in nesting LET (... That was genius (well, at least to me!). Thanks Victor and congratulations for your new milestone on your 5K subscribers. All the best my dear friend!
You seem to always have the solutions figured out. Thanks for your comments always
Hahaha Hello Victor... not quite: i have to watch your solution a few times to grasp all the concepts shown in your solution.... What i really like is the way you break down the problem into pieces so that the not so genius like me can understand. Thanks for your postings. I have learned from you quite a few tricks and patterns. Take care.
Greetings, Victor Sir...I greatly appreciate it.This Excel challenge series was something I was really looking forward to and loving.🤩😍
Yea, I always look forward to the series as well. I am glad you love it and learn from the series
@@ExcelMoments Always...looking forward more videos like this....
Espectacular !!!
Thanks
Love this!
Thanks 👌👌
Thank You!
You are welcome
minute 1:25 - the beauty and blocks...? maybe the beauty of solving a problem in blocks? 😁
It was actually "Building Blocks"
@@ExcelMoments Buildimg or Building 😁.... loving the good laughs at 10:40 🙌
@@ExcelMoments Victor, I'm going to study this formula a lot! a good refresher to get back at building new Excel charts with Dynamic arrays. I'm intrigued by a LET being inside a LET, yet amazed by this tutorial of yours! bravoo myfriend!
I've still not really figured how this works, I managed all the numbers, so say 12, 16 - 18 = 12 - 18,
it's the splitting and then re splitting, I shall persevere breaking bits down. 🤔🤔
Thanks Victor. Why didn’t we use Scan or Map instead of Reduce? Reduce should give us the last step only which is 81 in your example and not the full array isn’t ?
Lets take a case where we need the final result of stacking a,b,c,d together. SCAN gives the intermediate steps
Scan Step 1:a
Scan Step 2; a&b
Scan Step 3: a&b&c
Scan Step 4: a&b&c&d
So if you need the final result which is Step 4, then thats where a REDUCE comes in to get the last step because step1,2,3 are not relevant in this case
@@ExcelMoments understand now it is because I need the final Vstack result which the 4 numbers stacked together and not the first then the first and the second then the first,second and the third etc. Thanks Victoria for the explanation