formula for returning the largest letter in a series of letters
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
|