Try the following...
=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))
Hope this helps!
In article ,
"RoterRuter" wrote:
I have a worksheet with several columns that are data validated text. I want
to find out which of the entries is used the most and have that entered into
the last cell of the column. With numbers, I just used the mode function.
Can I do find the mode of text? Thanks
|