On Thu, 10 Nov 2005 07:20:15 -0800, "Calaw"
wrote:

Hi,
I have a list of names and I need to get the name with the highest in the
alphabetical order. I dont want to sort.
Thanks,

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/ (Version 4.01 or later).

If by "Highest" you mean that A is higher than B and so forth, use the formula:

=VSORT(Names,,1)

If you mean Z is higher than Y and so forth, then:

=VSORT(Names)

will do.




--ron