Mode function for text

  • Thread starter Thread starter Ed
  • Start date Start date
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
 
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.
 
Back
Top