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.

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.

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.

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.