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

1 comment:

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

    ReplyDelete