Hi everyone -
I appreciate some insight on the formula mode.sngl: I am using this to look at some columns of numbers and I have found that lets say I have 10 columns of numbers and there are two repeating sets of numbers (2's) and (5's). Each one of these repeats three times - the way the formula reads it should return a 2 as the mode. What mine is doing is what ever number appears first in the list of numbers is the one excel is picking for the mode....example: 1,1,5,5,5,2,2,2,3,7 mode = 5 when it is supposed to return the lowest mode of multiple modes which should be 2 in this case. If I change the order of the numbers and put a 2 in the list ahead of the 5's and both repeating three times then the mode chooses 2 as the mode....What is going on here??
Thank you in advance -
Chris