software

Hi,

I tried using the max function to find the highest name eg Zachary but it
only seems to work with numbers. I am I doing something wrong?

Is there some function to find the highest name in a list of names.

Its driving me crazy. Any help greatly appreciated.

Thanks

Sandra

On Tue, 14 Mar 2006 08:23:09 -0800, Grd gt; wrote:

gt;Hi,
gt;
gt;I tried using the max function to find the highest name eg Zachary but it
gt;only seems to work with numbers. I am I doing something wrong?
gt;
gt;Is there some function to find the highest name in a list of names.
gt;
gt;Its driving me crazy. Any help greatly appreciated.
gt;
gt;Thanks
gt;
gt;Sandra

What do you mean by quot;highestquot;?

If you mean the text string that will sort last in an Excel text sorted range,
then one way would be to download and install Longre's free morefunc.xll add-in
from xcell05.free.fr

Then use the formula:

=VSORT(rng)--ron

Try...

=INDEX(A2:A10,MATCH(0,IF(A2:A10lt;gt;quot;quot;,COUNTIF(A2:A10 ,quot;gt;quot;amp;A2:A10)),0))

....confirmed with CONTROL SHIFT ENTER, not just ENTER.

Hope this helps!

In article gt;,
Grd gt; wrote:

gt; Hi,
gt;
gt; I tried using the max function to find the highest name eg Zachary but it
gt; only seems to work with numbers. I am I doing something wrong?
gt;
gt; Is there some function to find the highest name in a list of names.
gt;
gt; Its driving me crazy. Any help greatly appreciated.
gt;
gt; Thanks
gt;
gt; Sandra

thanks ron

s

quot;Ron Rosenfeldquot; wrote:

gt; On Tue, 14 Mar 2006 08:23:09 -0800, Grd gt; wrote:
gt;
gt; gt;Hi,
gt; gt;
gt; gt;I tried using the max function to find the highest name eg Zachary but it
gt; gt;only seems to work with numbers. I am I doing something wrong?
gt; gt;
gt; gt;Is there some function to find the highest name in a list of names.
gt; gt;
gt; gt;Its driving me crazy. Any help greatly appreciated.
gt; gt;
gt; gt;Thanks
gt; gt;
gt; gt;Sandra
gt;
gt; What do you mean by quot;highestquot;?
gt;
gt; If you mean the text string that will sort last in an Excel text sorted range,
gt; then one way would be to download and install Longre's free morefunc.xll add-in
gt; from xcell05.free.fr
gt;
gt; Then use the formula:
gt;
gt; =VSORT(rng)
gt;
gt;
gt; --ron
gt;

Thanks this is what i was after. Works nicely
s

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =INDEX(A2:A10,MATCH(0,IF(A2:A10lt;gt;quot;quot;,COUNTIF(A2:A10 ,quot;gt;quot;amp;A2:A10)),0))
gt;
gt; ....confirmed with CONTROL SHIFT ENTER, not just ENTER.
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Grd gt; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I tried using the max function to find the highest name eg Zachary but it
gt; gt; only seems to work with numbers. I am I doing something wrong?
gt; gt;
gt; gt; Is there some function to find the highest name in a list of names.
gt; gt;
gt; gt; Its driving me crazy. Any help greatly appreciated.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Sandra
gt;

Domenic wrote...
gt;Try...
gt;
gt;=INDEX(A2:A10,MATCH(0,IF(A2:A10lt;gt;quot;quot;,COUNTIF(A2:A1 0,quot;gt;quot;amp;A2:A10)),0))
gt;
gt;...confirmed with CONTROL SHIFT ENTER, not just ENTER.
....

You could shrink that to the nonarray formula

=LOOKUP(2,1/(COUNTIF(A2:A10,quot;gt;quot;amp;A2:A10amp;quot;*quot;)=0),A2:A10)Thanks Harlan! Very interesting...

In article .comgt;,
quot;Harlan Grovequot; gt; wrote:

gt; Domenic wrote...
gt; gt;Try...
gt; gt;
gt; gt;=INDEX(A2:A10,MATCH(0,IF(A2:A10lt;gt;quot;quot;,COUNTIF(A2:A1 0,quot;gt;quot;amp;A2:A10)),0))
gt; gt;
gt; gt;...confirmed with CONTROL SHIFT ENTER, not just ENTER.
gt; ...
gt;
gt; You could shrink that to the nonarray formula
gt;
gt; =LOOKUP(2,1/(COUNTIF(A2:A10,quot;gt;quot;amp;A2:A10amp;quot;*quot;)=0),A2:A10)