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))
|