Hi Magnus,

I did enter the Formula using Control+Shift+Enter.

Suggestions welcome.

Thanks
Sam

Mangus Pyke wrote:
I'm not getting the correct value - I think it's because the Formula range (A-
J) encounters text values within the non-adjacent range; i.e assuming that
Columns B, D, F, H, and J are the five non-adjacent numerical columns, of
which I require the MODE value - columns A, C, E, G and I with text values
are being captured within the Formula below and may be distorting the result.

Please do not take offense to this, but given that this is an array,
did you enter it using Control+Shift+Enter?

MP

--
"Learning is a behavior that results from consequences."
B.F. Skinner


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1