thanks Ashish, really appreciated.
>
>From: ashish koul <koul.ash...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Thu, 6 January, 2011 11:50:17 AM
>Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
>values in a list of numbers ie. the max of the modes
>
>
>its array formula so u have to press ctrl +shift +enter then {} it will come
>automatically
>
> for offset check help =
>
>MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),"")) it will return the maximum row no
>which
>is having max value in range f2:f9
>
>
>
>
>
>On Thu, Jan 6, 2011 at 11:15 AM, hanumant shinde <hanumant_5...@yahoo.co.in>
>wrote:
>
>Hi Ashish,
>>
>>can you pls explain this.
>>{=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))-1,0)}
>>
>>
>>Also,why have u used {}. when to use them. if do F2 i get Value error. why is
>>it
>>so.
>>so many que :( can you please explain.
>>
>>
>>
>>
________________________________
From: ashish koul <koul.ash...@gmail.com>
>>To: excel-macros@googlegroups.com
>>Sent: Thu, 6 January, 2011 10:37:35 AM
>>Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
>>values in a list of numbers ie. the max of the modes
>>
>>
>>check the attachment see if it helps
>>
>>
>>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
>>>
>>
>>
>>--
>>
>>Regards
>>
>>Ashish Koul
>>akoul.blogspot.com
>>akoul.wordpress.com
>>My Linkedin Profile
>>
>>
>>PBefore printing, think about the environment.
>>--
>>
>>----------------------------------------------------------------------------------
>>
>>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>--
>
>Regards
>
>Ashish Koul
>akoul.blogspot.com
>akoul.wordpress.com
>My Linkedin Profile
>
>
>PBefore printing, think about the environment.
>
--
>----------------------------------------------------------------------------------
>
>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
