Count Most Frequently Occuring

  • I have a list of numbers in an Excel range. Most of the numbers are the same but some are not. I need a function that will go through the list and return the value which occurs most frequently. (Not the number of occurences but the actual value). I need to do this in VBA. Thanks.

  • Re: Counting The Occurences Of A Number And Returning The Max Value


    Quote from Kigol

    No reason whatsoever. Thank you. I feel stupid.


    Don't worry, it happens us all from time to time.


    By the way, TJ forgot to say, but... welcome to Ozgrid!

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!