From a list select the name with the most occurences
 

Thank you

From a list select the name with the most occurences
 

Hi,

If this is a question, try the following array formula

=INDEX(A1:A9,MATCH(MAX(COUNTIF(A1:A9,A1:A9)),COUNT IF(A1:A9,A1:A9),0))

Array - to enter the formula press Shift+Ctrl+Enter

Since the same range is used 5 times if you us are range name of N for that
range the formula simplifies to

=INDEX(N,MATCH(MAX(COUNTIF(N,N)),COUNTIF(N,N),0))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"akoobra" wrote:

Thank you