Thread
:
Find max value in one column and return the value of corrosponding cell in different column
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Find max value in one column and return the value of corrosponding cell in different column
Just another option:
Age 11:
=INDEX(B2:B7,MATCH(MAX((A2:A7=11)*C2:C7),(A2:A7=11 )*C2:C7))
Age 12:
=INDEX(B2:B7,MATCH(MAX((A2:A7=12)*C2:C7),(A2:A7=12 )*C2:C7))
As witht the others, entered as an array formula with Ctrl + Shift + Enter
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
wrote in message
oups.com...
Hi All,
Haveing a bad excel day - I am sure I have done this before but
racking my brains and can't remember!!
I have a list of scores for various tests listed by agegroup. I am
trying to summarise the data on a seperate worksheet to list who
attained the maximum value in each test for each agegroup. So using
the example below of the raw data I am trying to use a function to
find the MAX of T1 for age 11 (22) and age 12 (10). What I am trying
to do is use a function to list the owner of these MAX values listed
in column B
A B C D
Age Name T1 T2
11 George 10 5
11 Dave 15 2
11 Jim 22 1
12 Paul 5 8
12 James 4 10
12 Dylan 10 11
Can I apply a similar function to list the 'owner' of the max value?
Thanks in advance
Paul
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann