Formula Help

  • Thread starter Thread starter Erika
  • Start date Start date
E

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.
 
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
 
Back
Top