Hi,
I have excel table that looks like this:
text1
text2
text3
text2
text2
text2
text1
text3
text2
text2
text2
text2
The most repetitive text in this table is "text2". Now I want formula to automatically find most repetitive text and write it.
It would be best if it can be done within one cell.
Bookmarks