ExcelBanter - From a list select the name with the most occurences

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - From a list select the name with the most occurences (https://www.excelbanter.com/excel-worksheet-functions/235618-list-select-name-most-occurences.html)

akoobra

From a list select the name with the most occurences

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

Teethless mama

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

All times are GMT +1. The time now is 02:27 AM.