Have a look in the help index for LARGE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bertha needs help" wrote in
message ...
I have a list of 700 alarms in column A then In column B i have a formula
that counts how many times each alarm went off.

In another sheet i want to make a chart that shows the top 10 alarms that
went off that day.

What formula could i use to find the top 10 values?