finding a corresponding value in the same row in a different colou

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ingrid - 29 Jul 2007 20:34 GMT

Hi

I am trying to find a code that will allow me to find a maximum value in a
column (say column B) and then finds the corresponding value in the same row
in column A.

Thanks I am quite desprite so any advise would be fantastic

Reply to this Message

squenson - 29 Jul 2007 21:25 GMT

You can use the function MATCH to retrieve the row on which your value is,
then the function INDEX to retrieve the value in column A. Example: which
value is in column A in range A1:B10, where 5 is in colun B?
=INDEX(A1:B10,MATCH(5,B1:B10,0),1)

>Hi
>
[quoted text clipped - 3 lines]
>
>Thanks I am quite desprite so any advise would be fantastic

Reply to this Message

daddylonglegs - 29 Jul 2007 22:06 GMT

You can use

=INDEX(A:A(MATCH(MAX(B:B),B:B,0))

> You can use the function MATCH to retrieve the row on which your value is,
> then the function INDEX to retrieve the value in column A. Example: which
[quoted text clipped - 8 lines]
> >
> >Thanks I am quite desprite so any advise would be fantastic

Reply to this Message