I believe this is an index, match question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gilles Desjardins - 02 Feb 2007 19:29 GMT

Hi everyone,

Question: How do I find the max value in a two column table and reveal
(show) the text value that is written to the left of the value.

Home 25
Visitor 19
Stranger 33
Relative 5

I would like to display Stranger because the cell next to it is the MAX

Thanks,
Gilles

Reply to this Message

Dave Peterson - 02 Feb 2007 19:39 GMT

=index(a1:a10,match(max(b1:b10),b1:b10,0))

is one way

> Hi everyone,
>
[quoted text clipped - 10 lines]
> Thanks,
> Gilles

Signature

Dave Peterson

Reply to this Message

Gilles Desjardins - 03 Feb 2007 17:57 GMT

Thank you, Dave,

Works like a charm. Very appreciated.

Gilles

> =index(a1:a10,match(max(b1:b10),b1:b10,0))
>
[quoted text clipped - 14 lines]
>> Thanks,
>> Gilles

Reply to this Message