Forum Discussion
Finding the most occurring text in a column
I have a column that contains two text codes (ie, ab & cd). I want find which code occurs the most in the column and return that code to a cell:
ab
ab
cd
cd
ab
ab
ab
Would appreciate any pointers
5 Replies
Steve,
try this:
{=TEXTJOIN("/",TRUE,INDEX(A:A,N(IF(1,MODE.MULT(IF(A1:A99<>"",MATCH(A1:A99,A1:A99,0)))))))}Cudos to neopa and XOR LX.
many thanks
- Thanks so much.
an equal number would return the answer, "ab/cd"
- what would you expect if the number of the occurances are equal?
