I’m trying to use this function (irr), but doesn’t work when I use it with a matrix with more than two dimensions (appears "#NUM" in the cell).
So I don´t know if that formula doesn’t work in this cases or I´m doing something wrong.
I attached an example for more explanation.
I think I figured it out using sublist(), first(), last(). See the attached model and the Answer Item formula. It solved for Cash1.
Let me know if this is what you were looking for. It seems to be slightly off of what excel is giving you.