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!



    Excel MVP 2011-2014

    For more Excel memes: visit ==> 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!