array max dynamic

  1. L

    MAX array upto latest entry

    Hi, Here's my question - I can't set my table as an excel table or "list" to allow for a dynamic range that way. For this month, I can return the max value using the MAX formula as it is: =MAX(F4:F16) What i'd like to happen is for the F16 to change to F17 automatically when the new row...

Some videos you may like

This Week's Hot Topics