xirr subtotal

  1. W

    How to apply a formula to visible cells only without using subtotal

    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...

Some videos you may like

This Week's Hot Topics