Last Alphabetically

[mark.wolven]

Is there a function that would tell me the term that is last
alphabetically in a range? For a sample, the values look like IDs
like: ORIG257

Things like MAX and LARGE only work against numeric values. Is there a
function that I do not know about?

 

[T. Valko]

Try this:

=LOOKUP(2,1/(COUNTIF(A1:A10,">"&A1:A10)=0)/ISTEXT(A1:A10),A1:A10)