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