I've got a way of doing this that uses a mix of INDIRECT, ADDRESS and MATCH and it looks like this for row 2: =XIRR(INDIRECT(ADDRESS(ROW() ...
確定! 回上一頁