Mode function for text

E

Ed

Is there a function that will return the most frequently
occurring text for a specified range of cells? I know
that MODE will work for numeric values, but is there a
MODEA that will do this for text values?


Ed
 
L

Leo Heuser

Ed

Assuming data in B1:B20, this array formula will do the trick:

=INDEX(B1:B20,MODE(MATCH(B1:B20,B1:B20,0)))

Must be entered with <Shift><Ctrl><Enter> instead of <Enter>,
also if edited later. If done correctly, Excel will display the
formula in the formula bar enclosed by curly brackets { }
Don't enter these brackets yourself.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top