Thread: From a list select the name with the most occurences
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default From a list select the name with the most occurences
=INDEX(A2:A15,MODE(INDEX(MATCH(A2:A15,A2:A15,),)))


"akoobra" wrote:

Hi all

I am trying to get a cell to show the which name occurs the most frequently in a list.

Using Excel 2003 and 2007

koob

Reply With QuoteReply With Quote