Nice Harlan! Actually you pointed it out to me on another occasion but
I completely forgot about it. Thanks for reminding me. It's definitely
much more preferable than the one I offered.

In article .com,
"Harlan Grove" wrote:

Domenic wrote...
Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
...

Since any instance of the 'highest' value would be as good as any
other, both formulas could be reduced to

=LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30)

and

=LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30)

respectively, neither of which require array entry.