Most Used Name Forumla

M

Myrm

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.
 
R

Ron Coderre

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:A25),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)),COUNTIF(A2:A25,A1:A25),0))


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

XL2002, WinXP
 
M

Myrm

That did it!!

Thansk very much, Ron



Ron Coderre said:
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:A25),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)),COUNTIF(A2:A25,A1:A25),0))


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

XL2002, WinXP
Click to expand...
 
R

Ron Coderre

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


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

XL2002, WinXP
 
Top