Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|