How to break ties when using Large, Small formulas

Hi there. I think that this delivers what you need. the rows($1:1) bit gives you 1st, 2nd highest, meeting your criteria ad the +1/(Row(XXX)*10^10) bit makes each value totally unique.

It's an array formula...Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...