View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kjs kjs is offline
external usenet poster
 
Posts: 3
Default The Kth element in a text list

=Small(A1:A5,2) from
12
15
12
10
17
returns the value 12, but what from
def
ghi
qrs
def
abc
returns "def" as the second lowest, by sort order
or ascii value?
I can get as far as =MIN(CODE(A1:A5)) entered
as an array formula giving 97, the lowest ascii
value of the first letter, but then I come off the rails.
Any ideas?

kjs