Count

**wpm7113** · 06-10-2009, 04:57 AM

Hi,

Need advice. I have a spreadsheet that I would like to put a summary that can tell me what is the category have the highest name listed

**DonkeyOte** · 06-10-2009, 05:03 AM

Courtesy of Richard Schollar:

=INDEX(C5:C16,MODE(MATCH(C5:C16,C5:C16,0)))

**zbor** · 06-10-2009, 05:03 AM

...........................

**zbor** · 06-10-2009, 05:06 AM

That's better.. Mine don't even work

**zbor** · 06-10-2009, 05:56 AM

Book4(1).xls

here it is

**wpm7113** · 06-10-2009, 10:18 AM

Hi Zbor, this is cool. but I have one more question. some of the roll are empty and the formula does not work.
can you advice again..

Thanks

**DonkeyOte** · 06-10-2009, 02:26 PM

You could adjust the formula to become an array

=INDEX(C5:C16,MODE(IF(C5:C16<>"",MATCH(C5:C16,C5:C16,0))))
Committed with CTRL + SHIFT + ENTER

Thread: Count