Matching Data from 2 columns

[DeeLaa77]

Hi All,

I am trying to use a function to look at the data from 4 columns:

Name
Number of Times Attended
Total Score
Average

Now I want to return the name of the person with the largest average who has attended at least 5 times.

I have tried a few things but can't seem to do what I want. Any help would be much appreciated.

DeeLaa77

[rylo]

Hi

Say your data is in the range A1:D5, with headings in row 1, and data in the other rows, then try

=INDEX(A1:A5,SUMPRODUCT(--(B1:B5>=5),--(D1:D5=MAX(IF(B1:B5>=5,D1:D5))),ROW(D1:D5)))

This formula is to be array entered (ctrl, shift, enter)


rylo