Monday, 9 March 2015

How to Find and Fetch the Maximum Occurred or Repetitive String or Number in a Range in Excel

Excel Function to Find and Fetch the Most Occurred or Repetitive String or Number in a Range
Suppose we have a data of Month Names as shown below :

In the above data 'Mar' is repeated more no.of times. We can fetch that using the below Combo Formula. 

{ =INDEX($A$2:$A$16,MATCH(MAX(COUNTIF($A$2:$A$16,$A$2:$A$16)),COUNTIF ($A$2:$A$16,$A$2:$A$16),0)) }

This is an array formula so that we have to use 'Ctl'+'Shift'+'Enter' key combination after enter the formula to get the result .

This will workout for numbers also.


--------------------------------------------------------------------------------------------------------
Thanks, TAMATAM ; Business Intelligence & Analytics Professional
--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts