Most Used Name Forumla
 

Hi

I have created an Excel 2007 spreadsheet in which I list the names of people
who contact my services. How do I get Excel to place the name of the person
who calls me most into another cell?

Thank you.

Most Used Name Forumla
 

Try something like this:

With
A2:A25 containing Names

This regular formula returns the most occurring name:
B2:
=INDEX(A2:A25,MATCH(MAX(INDEX(COUNTIF(A2:A25,A2:A2 5),0)),INDEX(COUNTIF(A2:A25,A2:A25),0),0))

OR....this ARRAY FORMULA version (committed with ctrl+shift+enter)
B2: =INDEX(A2:A25,MATCH(MAX(COUNTIF(A2:A25,A1:A25)),CO UNTIF(A2:A25,A1:A25),0))


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Myrm" wrote:

Hi

I have created an Excel 2007 spreadsheet in which I list the names of people
who contact my services. How do I get Excel to place the name of the person
who calls me most into another cell?

Thank you.

Most Used Name Forumla
 

That did it!!

Thansk very much, Ron



"Ron Coderre" wrote:

Try something like this:

With
A2:A25 containing Names

This regular formula returns the most occurring name:
B2:
=INDEX(A2:A25,MATCH(MAX(INDEX(COUNTIF(A2:A25,A2:A2 5),0)),INDEX(COUNTIF(A2:A25,A2:A25),0),0))

OR....this ARRAY FORMULA version (committed with ctrl+shift+enter)
B2: =INDEX(A2:A25,MATCH(MAX(COUNTIF(A2:A25,A1:A25)),CO UNTIF(A2:A25,A1:A25),0))


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Myrm" wrote:

Hi

I have created an Excel 2007 spreadsheet in which I list the names of people
who contact my services. How do I get Excel to place the name of the person
who calls me most into another cell?

Thank you.

Most Used Name Forumla
 

You're very welcome, Myrm.....Thanks for the feedback.


***********
Regards,
Ron

XL2002, WinXP


"Myrm" wrote:

That did it!!

Thansk very much, Ron



"Ron Coderre" wrote:

Try something like this:

With
A2:A25 containing Names

This regular formula returns the most occurring name:
B2:
=INDEX(A2:A25,MATCH(MAX(INDEX(COUNTIF(A2:A25,A2:A2 5),0)),INDEX(COUNTIF(A2:A25,A2:A25),0),0))

OR....this ARRAY FORMULA version (committed with ctrl+shift+enter)
B2: =INDEX(A2:A25,MATCH(MAX(COUNTIF(A2:A25,A1:A25)),CO UNTIF(A2:A25,A1:A25),0))


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Myrm" wrote:

Hi

I have created an Excel 2007 spreadsheet in which I list the names of people
who contact my services. How do I get Excel to place the name of the person
who calls me most into another cell?

Thank you.