Biff,

Your "student" could have provided the formulae. <BG

Remember our discussion on retrieving the nth element in a data set? I want to post my discovery. Please look for my post cause I always appreciate your comments.

By the way, do you know that the "grasshopper" has made more noises again?

Epinn

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