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