| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I find the "Calculated Field" in Office 2007 version? | Excel Worksheet Functions | |||
| Looking up the results from the function "LARGE" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
| Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) | |||
Threaded Mode
