Nice one! Thanks Harlan!

In article <[email protected]>,
"Harlan Grove" <[email protected]> wrote:

> Domenic wrote...
> >Assuming that A1:A10 contains your text values...
> >
> >B1, copied down:
> >
> >=(COUNTIF($A$1:$A$10,">"&A1)+1)+(COUNTIF($A$1:A1,A1)-1)
> >
> >C1:
> >
> >=INDEX(A1:A10,MATCH(MIN(B1:B10),B1:B10,0))
> ...
>
> Ancillary cells not needed. This can be done with a single nonarray
> formula.
>
> =LOOKUP(2,1/(COUNTIF(A1:A10,">"&A1:A10)=0),A1:A10)