One way

Array-entered (press CTRL+SHIFT+ENTER):
=INDEX(B2:B7,MATCH(MAX(IF(A2:A7=11,C2:C7)),IF(A2:A 7=11,C2:C7),0))
will return the name: Jim, who has the max score for age group: 11 for T1

Note that in the event of any ties in the max score, the expression will
return the first name (the one higher up in the list)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
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