Learn how to calculate payback and discounted payback in Excel with formulas, SCAN, XMATCH, LET, and SWITCH, plus partial-year and error handling ...
Take, for example, a list of employees in an organisation. These could be stored in an array called 'Employees' with the data typestring.