Forum Discussion
finding most frequently occurring text
hello Everyone How can l find the most occurring text in a column in an excel worksheet? I tried using YouTube videos but they didn't really help.
A formula that will work in older versions of Excel:
=INDEX(A2:A22,MODE(MATCH(A2:A22,A2:A22,0)))
Change A2:A22 to the ran