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.