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

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts