| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MAX formula for alphabetical letters
"Will Grattan" wrote:
Seems like it must be simple! I have a row of alphabetical letters from A-Z and I would like to be able to formulate what the highest alphabetical letter in that row (Z being the highest). The result therefore is the letter that is the MAX. Help much appreciated One way, in a helper row, put the formula =CODE(A1) and copy for as many cells as required. Then you can determine the MAX value and turn it back into a letter with CHAR like this - =CHAR(MAX(A2:E2)) HTH |
|
#2
|
|||
|
|||
|
=CHAR(MAX(CODE(IF(1:1<"",1:1,0))))
Array-entered, meaning press ctrl + shift + enter. HTH Jason Atlanta, GA "Will Grattan" wrote: Seems like it must be simple! I have a row of alphabetical letters from A-Z and I would like to be able to formulate what the highest alphabetical letter in that row (Z being the highest). The result therefore is the letter that is the MAX. Help much appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula | Excel Worksheet Functions | |||
| Can I use AutoFill or a formula to fill a series of letters? | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Linear Mode
