Mode function in excel using Text
How about a *non* array formula:
=INDEX(A1:A9,MODE(MATCH(A1:A9,A1:A9,0)))
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JMB" wrote in message
...
One way - assume your data is in A1:A9
=INDEX(A1:A9,MATCH(MAX(COUNTIF(A1:A9,A1:A9)),COUNT IF(A1:A9,A1:A9),0))
array entered w/Cntrl+Shift+Enter (or you'll likely get an error).
"johnskate17" wrote:
I am having trouble finding a function in excel that is similar to the
MODE
function, but can work using a column of text, and return the phrase
that is
found most often.
|