Possible If Function?

[sot]

I have a list of students in my first column and their grades in the second
column. I know my highest grade is 98, but I want to know the name of the
student that scored this grade. Can I do this with an IF?

Tom 50
Dick 60
Harry 98
Bob 70

 

[Stephen]

I have a list of students in my first column and their grades in the second
column. I know my highest grade is 98, but I want to know the name of the
student that scored this grade. Can I do this with an IF?

Tom 50
Dick 60
Harry 98
Bob 70

I don't think you can do it with an IF statement, but (assuming your data
are in A1:B4) you can use this formula:
=OFFSET(A1,MATCH(MAX(B1:B4),B1:B4)-1,0)

 

[MartinW]

Hi,

With your students in A and grades in B try this in C1,
=INDEX(A:A,(MATCH(MAX(B:B),B:B,0)))

HTH
Martin

 

[MartinW]

Hi,

I'm not sure what your ultimate goal is but this may be helpful.
With your students in column A and grades in column B

Try this in C1
=B1-ROW()/10^10

This in D1
=INDEX(A:A,(MATCH(LARGE(C:C,ROW()),C:C,0)))

This in E1
=INDEX(B:B,(MATCH(LARGE(C:C,ROW()),C:C,0)))

Select C1:E1 and drag down to the end of your data.

Hide column C.

As you input grades in column B, columns D and E
will keep a running tally of highest to lowest.

HTH
Martin