XIRR formula across multiple sheets
The workbook from this video can downloaded here:
https://spreadsheetvault.com/xirr-ind...
Goal: We want to calculate the respective IRR for each entity on the summary sheet. Each entity contains its own worksheet, thus we need to dynamically reference the XIRR formula based on the individual worksheet name.
This is a follow-on to an earlier video on the XLOOKUP function across worksheets.
Watch video XIRR formula across multiple sheets online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,278 once and liked it 9 people.