Try something like this:

With
A1:A5 containing this list
Fred
Ben
Karla
Zack
David

This formula returns the "Minimum" name, alphabetically
B1: =INDEX(A1:A5,MATCH(0,INDEX(COUNTIF(A1:A5,"<"&A1:A5 ),0),0))
In the above example: Ben

This formula returns the "Maximum" name, alphabetically
C1:
=INDEX(A1:A5,MATCH(MAX(INDEX(COUNTIF(A1:A5,"<"&A1: A5),0)),INDEX(COUNTIF(A1:A5,"<"&A1:A5),0),0))
In the above example: Zack

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Carlo" wrote:

Hi there,

I have a list of names like Andrew, Zachary, Jeff etc and I need to find out
which one is the highest alphabetically. The max function doesn't seem to
work.

Is this possible?

Thanks

Carlo