Search This Blog

Friday, 17 August 2012

FIND OUT MAXIMUM OCCURED TEXT IN A RANGE



Array formula in B2:
=INDEX($A$2:$A$9,MATCH(MAX(COUNTIF($A$2:$A$9,$A$2:$A$9)),COUNTIF($A$2:$A$9,$A$2:$A$9),0)) with CSE
Posted by at

1 comment:

  1. Unknown21 October 2018 at 23:43

    Why not this (Non-Array):-
    INDEX(A2:A9,MODE(MATCH(A2:A9,A2:A9,0)))

    ReplyDelete

Subscribe to: Post Comments (Atom)