Hello,

I’m trying to evaluate the mode of a dataset consisting of 105,192 values. The values are a list of decimal degrees, each rounded to the nearest 10 degrees using the formula =ROUND(G1/10,0)*10 where cells G1 to G105192 contain floating point values between 0 and 360. I have set the number format of these cells to ‘general’ with no decimal places and one leading zero.

When I try and calculate the mode.sngl on parts of the list, it works fine. However, if I try to calculate for the whole list, I get Err:538. I can’t see this in the list of standard error codes, so I’m not sure what it means (and am not keen to download the source to find out, though I suppose that is a possibility if no-one here happens to know).

Other functions such as min, max and average work fine on the list. I was wondering if perhaps there is a maximum number of values that mode.sngl will accept in a range?

Thanks in advance,

Sam