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

1. ## 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,

2. ## Re: Is there a function to give us the highest value in a list of tex

highest??
--
Don Guillett
SalesAid Software
donaldb@281.com
"Calaw" <Calaw@discussions.microsoft.com> wrote in message
news:22416431-8101-4194-A04E-7F9FF5FAE7AC@microsoft.com...
> 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,

3. ## Re: 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" <Calaw@discussions.microsoft.com>
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,

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

4. ## Re: 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: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.

Hope this helps!

In article <22416431-8101-4194-A04E-7F9FF5FAE7AC@microsoft.com>,
"Calaw" <Calaw@discussions.microsoft.com> 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,

5. ## Re: 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 <domenic22@sympatico.ca> 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.
>
>Hope this helps!
>
>In article <22416431-8101-4194-A04E-7F9FF5FAE7AC@microsoft.com>,
> "Calaw" <Calaw@discussions.microsoft.com> 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

6. ## Re: 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: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.

7. ## Re: 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.

"Harlan Grove" <hrlngrv@aol.com> 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.

8. ## Re: 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" <hrlngrv@aol.com> 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

9. ## Re: Is there a function to give us the highest value in a list of tex

Agreed! Definitely nicer!

In article <nau7n15ja0kju8gsnpprrk7fv0t9q3fp28@4ax.com>,
Ron Rosenfeld <ronrosenfeld@nospam.org> wrote:

> On 10 Nov 2005 11:51:54 -0800, "Harlan Grove" <hrlngrv@aol.com> 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1