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.