Uploaded April 2014 | Updated September 2026, 53 minutes ago

---

Do you create solutions in Excel for other people? If so, it's important that they understand the entire solution and can modify it when required.
In this video I combine several simple functions to create a solution (instead of creating a complex array formula that many won't understand).
Download the Excel file from my OneDrive here: http://1drv.ms/1bYwrTa