Biff,

Thanks for your reply. Unhappily, I think this treatment of a multi-modal
array is erroneous from a statistical standpoint. Any thoughts about how I
can raise this with Microsoft? Mark

"Biff" wrote:

That's just how it works. Returns the first instance, just like a Vlookup,
Match.

Biff

"Mark Neuffer" <Mark wrote in message
...
I am using "mode" in Excel to return the most common numeric value in a
questionnaire field. One domain contains two equally-represented values
("1"
and "2")."Mode" returns a value of "1" if the list is sorted in ascending
order, and returns "2" if the list is unsorted. I can find no detail from
our cretinous friends at Microsoft as to why this might be so. Any
insights
would be appreciated.