Excel Challenge: Expand grouped Intervals -Reduce Function

[@IvanCortinas_ES]

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.

[@ExcelMoments]

hahaha, I ove this breakdown 😁😁 Thanks for the feedback and kind words

[@InTheLongRunRedux]

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!

[@HauiUSA]

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.

[@ExcelMoments]

Thanks for the feedback on the video. I could not have written it better

[@ohdjrp4]

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

[@ExcelMoments]

@@ohdjrp4 Thanks

[@petercompton538]

Lovely solution! I have not used MAP or REDUCE much so far, so that was really useful. Thanks Victor

[@ExcelMoments]

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

[@jazzista1967]

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!

[@ExcelMoments]

You seem to always have the solutions figured out. Thanks for your comments always

[@jazzista1967]

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.

[@rtrbs8383]

Greetings, Victor Sir...I greatly appreciate it.This Excel challenge series was something I was really looking forward to and loving.🤩😍

[@ExcelMoments]

Yea, I always look forward to the series as well. I am glad you love it and learn from the series

[@rtrbs8383]

@@ExcelMoments Always...looking forward more videos like this....

[@bevonclarke]

Another master explanation! Thank you

[@ExcelMoments]

Thank you for the feedback

[@Fxingenieria]

Espectacular !!!

[@ExcelMoments]

Thanks

[@spilledgraphics]

minute 1:25 - the beauty and blocks...? maybe the beauty of solving a problem in blocks? 😁

[@ExcelMoments]

It was actually "Building Blocks"

[@spilledgraphics]

@@ExcelMoments Buildimg or Building 😁.... loving the good laughs at 10:40 🙌

[@spilledgraphics]

@@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!

[@ankursharma6157]

Thank You!

[@ExcelMoments]

You are welcome

[@miladarastoueian2874]

Very Good

[@ExcelMoments]

@@miladarastoueian2874 Thank you

[@Mark-sf4kh]

Love this!

[@ExcelMoments]

Thanks 👌👌

[@nadermounir8228]

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 ?

[@ExcelMoments]

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

[@nadermounir8228]

@@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

[@williamarthur4801]

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. 🤔🤔