3 highest values

[Bridge]

hello everyone, i've been trying to figure out what formula i can use t
find 3 highest values in a row. in my case am trying to compile studen
marks to get only the best 3 into a cell, i was able to get the highes
only 1 but i need all the three values. see the attached image

thanks alot
Bridg

+-------------------------------------------------------------------
|Filename: excel.jpg
|Download: http://www.pcreview.co.uk/forums/attachment.php?attachmentid=1833
+-------------------------------------------------------------------

 

[Bob Phillips]

=LARGE(A2:Z2,1)
=LARGE(A2:Z2,2)
=LARGE(A2:Z2,3)

if you want to sum them, use

=SUM(LARGE(A1:Z1,{1,2,3}))

 

[Bridge]

thanks alot Bob Phillips it worked perfect :