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.
Count Most Frequently Occuring
-
-
Re: Counting The Occurences Of A Number And Returning The Max Value
Any reason why you cannot just use =MODE() on the sheet instead of using VBA?
TJ
-
Re: Counting The Occurences Of A Number And Returning The Max Value
Quote from KigolNo 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!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!