Is there a function to give us the highest value in a list of tex
 

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,

Is there a function to give us the highest value in a list of tex
 

highest??
--
Don Guillett
SalesAid Software

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

Is there a function to give us the highest value in a list of tex
 

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

Is there a function to give us the highest value in a list of tex
 

Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A1 0),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A1 0),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

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

Hope this helps!

In article ,
"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,

Is there a function to give us the highest value in a list of tex
 

On Thu, 10 Nov 2005 11:49:07 -0500, Domenic wrote:

Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A 10),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A 10),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

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

Hope this helps!

In article ,
"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,


Nice
--ron

Is there a function to give us the highest value in a list of tex
 

Domenic wrote...
Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

Since any instance of the 'highest' value would be as good as any
other, both formulas could be reduced to

=LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30)

and

=LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30)

respectively, neither of which require array entry.

Is there a function to give us the highest value in a list of tex
 

Nice Harlan! Actually you pointed it out to me on another occasion but
I completely forgot about it. Thanks for reminding me. It's definitely
much more preferable than the one I offered.

In article .com,
"Harlan Grove" wrote:

Domenic wrote...
Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A 10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

Since any instance of the 'highest' value would be as good as any
other, both formulas could be reduced to

=LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30)

and

=LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30)

respectively, neither of which require array entry.

Is there a function to give us the highest value in a list of tex
 

On 10 Nov 2005 11:51:54 -0800, "Harlan Grove" wrote:

Domenic wrote...
Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1: A10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1: A10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

Since any instance of the 'highest' value would be as good as any
other, both formulas could be reduced to

=LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30)

and

=LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30)

respectively, neither of which require array entry.

Nicer.
--ron

Is there a function to give us the highest value in a list of tex
 

Agreed! Definitely nicer! :)

In article ,
Ron Rosenfeld wrote:

On 10 Nov 2005 11:51:54 -0800, "Harlan Grove" wrote:

Domenic wrote...
Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1: A10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1: A10),1),
COUNTIF(A1:A10,"<"&A1:A10),0))

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

Since any instance of the 'highest' value would be as good as any
other, both formulas could be reduced to

=LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30)

and

=LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30)

respectively, neither of which require array entry.

Nicer.
--ron