Uploaded March 2019 | Updated September 2026, 2 hours ago

---

This was a challenge from a work colleague. I love this array solution!
Do you have another solution? Note that although the array is a bit heavy there are no slow volatile functions used (i.e. indirect). My blog post: myspreadsheetlab.com/largest-number-inside-alphanumeric-string
myspreadsheetlab.com/extract-largest-number-power-query-flash-fill-solutions