View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bertha needs help[_2_] Bertha needs help[_2_] is offline
external usenet poster
 
Posts: 10
Default Finding the top 10

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?