a mode function that works on text?

[basher450]

hi

very simple, I have 10 cells that have text strings in each one. (10 names of people to be exact)

and I want to know which one (of those names) appears more than others.

the mode function is just what would work for me in case these were numbers.

what can I use in this case? [/b]

 

[Von Pookie]

This seems to work for me:

Book1
	A	B	C	D
1	Jon		Jim
2	Bill
3	Tess
4	Jim
5	Carol
6	Jim
7	Lisa
8	Rosa
9	Tim
10	Jim
Sheet1

Formula in C1 is:
=INDEX(A1:A10,MATCH(MAX(COUNTIF(A1:A10,A1:A10)),COUNTIF(A1:A10,A1:A10),0))

Note: This is an array formula. You must press Ctrl+Shift+Enter for the formula to work correctly. If you enter the formula and just press enter as normal, it will not work.

 

[basher450]

thanks

 

[basher450]

wait, it didn'nt work for me.

I got #N/A

could it be because my list of names is in colums, not rows?

 

[Von Pookie]

Change the cell references in the formula to whatever range you're trying to check, and remember to press ctrl+shift+enter to enter the formula, not just enter. If you have to, select the cell, press F2 and then press ctrl+shift+enter and see if the result changes from the N/A.