Hi All, Have a look in the attached excel and you can find the solution.
The formula is given below for your reference. Adapt the Cell Range A3:A8 to your desired Range. =IF(COUNTIF(A3:A8,LARGE(A3:A8,1))=COUNTIF(A3:A8,MODE(A3:A8)),LARGE(A3:A8,1),MODE(A3:A8)) *Suggestions For All* * * 1) Always try to avoid the usage of the helper column(s). 2) Never go for array formula when the same can be achieved by normal one. 3) Please don't go for VBA (Macro) solution for simple things when excel holds lot of functions to do the work as expected (Like the above). ----------------------- Ms.Exl.Learner ----------------------- On Thu, Jan 6, 2011 at 6:17 AM, Kim <anast...@gmail.com> wrote: > Hi, > I have a list of numbers and I need to find the highest of the most > frequent occurrances. > > For example: > > List 1 > 1 > 3 > 3 > 4 > 4 > > Should return the value 4 because its the highest of the most > frequent > occurrances of any number. > > List 2 > 1 > 3 > 3 > 3 > 4 > 4 > > Should return 3 because it's the most frequent occurrance outright. > > I've tried using the mode command but it returns the first of the > most > frequent occurances but I want the highest of the most frequent > occurrances. > > Any help would be greatly appreciated. > > Thanks > > Kim > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Solution (9-Jan-2011).xls
Description: MS-Excel spreadsheet
