| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list and adding numeric values to text | Excel Discussion (Misc queries) | |||
| Cells within a list to display a certain text but have different v | Excel Discussion (Misc queries) | |||
| Removing leading decimals for text list | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
