max two values in a range

  1. L

    Highest numbers formula (MAX two values)

    Hi all, Maybe somebody can help. I'm a bit puzzled with this: Values in cells of my_named_range: 1 2 3 4 5 Formula in another cell: =max(my_named_range) Formula result: 5 Easy so far, what I'm trying to get now is a formula to get the second highest value (4) but I don't seem to find the...

Some videos you may like

This Week's Hot Topics