Formula Help

[Erika]

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.

 

[Gary''s Student]

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