Thread: MODE
View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Micayla Bergen" wrote...
help says i cant use the mode function on text in a table, is there an
equivalent function for text?


If your text is in a single column, multiple row range like A1:A20, you
could use

=INDEX(A1:A20,MODE(MATCH(A1:A20,A1:A20,0)))

I believe Leo Heuser came up with this.