Try this array formula** (does not account for empty cells):

For an ascending sort:

=INDEX(rng,MATCH(SMALL(COUNTIF(rng,"<"&rng),ROWS($ 1:1)),COUNTIF(rng,"<"&rng),0))

For a descending sort simply change each instance of "<" with "".

Biff

"Smibes" wrote in message
...
Is there a formula function that will find 'n'th largest (or smallest)
alphanumeric field (like "Large" does with numerics).

I am trying to use formulas to move a column of alphnumeric data from one
column to another with the new column sorted alphanumerically. To move a
column of values I would use "Large" however that function does not work
with
text.

Thanks in advance.
John