"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.
|