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