View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smibes Smibes is offline
external usenet poster
 
Posts: 8
Default Function to find 'n'th largest alphanumeric field (like "Large")

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