Excel Challenge: Expand grouped Intervals -Reduce Function
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
https://docs.google.com/spreadsheets/...