I am trying to apply the XIRR formula to data that I have selected by a filter. I want the result of the XIRR formula to vary based on the rows of data that are visible after being filtered. If XIRR was one of the 9 formulas supported in subtotal it would be great, but it is not. Any ideas?
Thanks,
Will
Thanks,
Will