I checked the OOXML specification --
it does not define the behavior in the presence of duplicate entries.
So if the apparent behavior of Excel
appears reasonable, I agree with documenting that.
-Rob
Eike Rathke <>
01/18/2008 09:29 AM
To
cc
Subject
Re: [office-formula] MATCH function
Hi Kohei,
On Thursday, 2008-01-17 16:41:51 -0500, Kohei Yoshida wrote:
> [... MATCH last/first of sorted source range for <=query ...]
>
> Now the real question is whether it is worthwhile to standardize this
> behavior.
I think so. People may rely on it to retrieve an index into related data
records.
I'll add this to the spec. Thanks for pointing out.
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's
list.
atts7cxp.dat
