View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default Finding the top 10

The problem with this formula is that, even if you set match_type to 0
(exact match), it will not work if there are cells i the K column that
have the same value.
And it seems possible that in this case there are more than one alarm
type/name that have the same number of times that they have went off.

Lars-Åke

On Tue, 5 Aug 2008 10:12:40 -0500, "Don Guillett"
wrote:

Try this.
=INDEX(A:A,MATCH(LARGE(K:K,ROW(A1)),K:K))