Thread: I need function that can list the "top ten" highest results
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default I need function that can list the "top ten" highest results
=LARGE($A$1:$A$100,ROW(A1))

and copy down for 9 more cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DClark5412" wrote in message
...
Can anyone help me find a function in excel that will find the top ten
highest scores in my data?



Reply With QuoteReply With Quote