Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D the
formula would return 'D'

Please help

Give this a try (tested it quickly & will work only on single characters).
Enter it as an array formula, meaning enter it by pressing Ctrl-Shift-Enter

=CHAR(MAX(CODE(A1:A4)))


"Modus" wrote:

Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D the
formula would return 'D'

Please help

Try...

=LOOKUP(2,1/(COUNTIF(A1:A4,""&A1:A4&"*")=0),A1:A4)

Hope this helps!

In article ,
Modus wrote:

Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D the
formula would return 'D'

Please help

try this ARRAY formula to account for upper and lower.
=MAX(IF(CODE(UPPER($C$12:$C$21)),MAX(CODE($C$12:$C $21))))

--
Don Guillett
SalesAid Software

"Duke Carey" wrote in message
...
Give this a try (tested it quickly & will work only on single characters).
Enter it as an array formula, meaning enter it by pressing
Ctrl-Shift-Enter

=CHAR(MAX(CODE(A1:A4)))


"Modus" wrote:

Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D
the
formula would return 'D'

Please help

or this array formula
=MAX(IF(ISNUMBER(CODE($C$12:$C$31)),CODE($C$12:$C$ 31),""))

--
Don Guillett
SalesAid Software

"Duke Carey" wrote in message
...
Give this a try (tested it quickly & will work only on single characters).
Enter it as an array formula, meaning enter it by pressing
Ctrl-Shift-Enter

=CHAR(MAX(CODE(A1:A4)))


"Modus" wrote:

Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D
the
formula would return 'D'

Please help