if statement issue

[headford]

I am trying to create an if statement that will calculate and find the first place student and award him/her first place the rest of the entries should remain blank. I have added up all the marks into one column.

[daffodil11]

Assuming your marks are in A1:A50, you would then put in B1:

=IF(A1=MAX($A$1:$A$700),"FIRST PLACE","")

and then copy downwards