Prev: very urgent : to write the value of next column of the same row
Next: Multiple Rows of Sheet Tabs
From: sarahphonics on 27 Apr 2010 05:14
I have a list of data as follows

A B C
1 Belfast 21
2 South 36 =abs(B1-B2)
3 Laganbank 25 =abs(B1-B3)
4 Balmoral 19 =abs(B1-B4)

What I want is to find the max value in column C and return the
corresponding name from column A. So in this case, C2 is highest (15) so the
value returned would be "South".

Note: The numbers in column B are linked to another table and have many
decimal places. they are not just typed whole numbers.
From: Jacob Skaria on 27 Apr 2010 05:23
Try the INDEX() MATCH() combination

=INDEX(A1:A4,MATCH(MAX(C1:C4),C1:C4,0))

--
Jacob (MVP - Excel)


"sarahphonics" wrote:

> I have a list of data as follows
>
> A B C
> 1 Belfast 21
> 2 South 36 =abs(B1-B2)
> 3 Laganbank 25 =abs(B1-B3)
> 4 Balmoral 19 =abs(B1-B4)
>
> What I want is to find the max value in column C and return the
> corresponding name from column A. So in this case, C2 is highest (15) so the
> value returned would be "South".
>
> Note: The numbers in column B are linked to another table and have many
> decimal places. they are not just typed whole numbers.
From: sarahphonics on 27 Apr 2010 10:55
worked perfectly. thank you

"Jacob Skaria" wrote:

> Try the INDEX() MATCH() combination
>
> =INDEX(A1:A4,MATCH(MAX(C1:C4),C1:C4,0))
>
> --
> Jacob (MVP - Excel)
>
>
> "sarahphonics" wrote:
>
> > I have a list of data as follows
> >
> > A B C
> > 1 Belfast 21
> > 2 South 36 =abs(B1-B2)
> > 3 Laganbank 25 =abs(B1-B3)
> > 4 Balmoral 19 =abs(B1-B4)
> >
> > What I want is to find the max value in column C and return the
> > corresponding name from column A. So in this case, C2 is highest (15) so the
> > value returned would be "South".
> >
> > Note: The numbers in column B are linked to another table and have many
> > decimal places. they are not just typed whole numbers.
 | 
Pages: 1
Prev: very urgent : to write the value of next column of the same row
Next: Multiple Rows of Sheet Tabs