4 ms·
Ha! That is so cool. I was super interested in the idea so tried doing it myself without looking at your solution and came up with a quite an elegant solution u
by lbatchelor 6y ago
Ha! That is so cool. I was super interested in the idea so tried doing it myself without looking at your solution and came up with a quite an elegant solution using only 8 formulas
and some named ranges (could be 4 if you inlined them more but I kept them separate for clarity).
https://docs.google.com/spreadsheets/d/1T3bv8ThluHc18ghI8u9mrJKy_wB7ddxyFlBqGsqM74U/ https://docs.google.com/spreadsheets/d/1T3bv8ThluHc18ghI8u9m...
Thank you for the inspiration!
- heinrichhartman 6y agoThanks for sharing. Really surprised how straight forward your solution is! Learned about REGEXEXTRACT and parametrized Strings. Powerfull stuff. As my job involves more and more Google Sheets Engineering lately. I really appreciate this kind of hacks!