Conditional MAX Function

  • Re: Max Function By Account Number

    Try this array formula (confirmed with CTRL+Shift+Enter) in N2 and copied down.

  • Re: Max Function By Account Number

    Hello Keith,

    Try this formula in N2 copied down


    It's an array formula and therefore needs to be confirmed with CTRL+SHIFT+ENTER. To do that select cell with formula and press F2. Then hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula in the formula bar

    Note: You probably don't need column L, this would do the same for your example:


    also confirmed with CTRL+SHIFT+ENTER

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!