| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
What formula would I use to find the highest alphabetical character in a row?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Define Highest. The value closest to a or to z???
-- HTH... Jim Thomlinson "Bradbell" wrote: What formula would I use to find the highest alphabetical character in a row? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Highest meaning the closest to Z
"Jim Thomlinson" wrote: Define Highest. The value closest to a or to z??? -- HTH... Jim Thomlinson "Bradbell" wrote: What formula would I use to find the highest alphabetical character in a row? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Characters in row 1
In A2 enter =CODE(A1) Copy/drag across. In A3 enter =MAX(2:2) Gord Dibben MS Excel MVP On Mon, 14 Apr 2008 09:35:04 -0700, Bradbell wrote: Highest meaning the closest to Z "Jim Thomlinson" wrote: Define Highest. The value closest to a or to z??? -- HTH... Jim Thomlinson "Bradbell" wrote: What formula would I use to find the highest alphabetical character in a row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Excel formulas | Excel Discussion (Misc queries) | |||
| Excel Formulas | Excel Worksheet Functions | |||
Linear Mode
