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
=LET(A,DROP(REDUCE("",UNIQUE(A1:A14),LAMBDA(x,y,VSTACK(x,HSTACK(y,COUNTIF(A1:A14,y))))),1),SORTBY(A,TAKE(A,,-1),-1))
With Office 365 or Excel for the web i'd return the sorted number of occurrences of all words. This way i'd easily see if there are multiple most frequently occurring words.
