Quote Originally Posted by Domenic View Post
Unless the data has one value occurring more than once, the formula will return #N/A. Is this the case?
You know, I've been using this formula all this time and it looks like it was tricking me. It appears that if more than one value have the same number of occurrences it will pick one of them as the result of the formula. Is this correct?