Assuming there are no numbers in the range:

For the first alphabetically:

=LOOKUP(2,1/((COUNTIF(rng,"<"&rng)=0)*(rng<"")),rng)

For the last alphabetically:

=LOOKUP(2,1/((COUNTIF(rng,""&rng)=0)*(rng<"")),rng)

Biff

"Carlo" wrote in message
...
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