Posted to microsoft.public.excel.misc
|
|
Mode function in excel using Text
See this:
http://tinyurl.com/2gq3td
--
Biff
Microsoft Excel MVP
"Karma2400" wrote in message
...
Hi Guys,
Im also doing something similar to this and i notice that this array uses
the "MAX" function .. is there any way to adapt this array to find the 2nd
most common and 3rd most common ? .. the same way in which you would use
the
"LARGE" function ?
Michael -
"JMB" wrote:
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.
|