ExcelBanter - Formula Help

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

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

- - Formula Help (https://www.excelbanter.com/excel-worksheet-functions/226397-formula-help.html)

Is there a formula that can tell me the person with the highest number of
entries based on the names listed in a column.

Every time a suggestion is submitted it is added to the spreadsheet, I want
to know who has submitted the most.

Say we have names in A1 thru A100 with no blanks. In B1 enter:

=INDEX(A1:A100,MODE(MATCH(A1:A100,A1:A100,0)))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.

Remember: No blanks
--
Gary''s Student - gsnu200842

"Erika" wrote:

Is there a formula that can tell me the person with the highest number of
entries based on the names listed in a column.

Every time a suggestion is submitted it is added to the spreadsheet, I want
to know who has submitted the most.