Send gnumeric-list mailing list submissions to
gnumeric-list gnome org
To subscribe or unsubscribe via the World Wide Web, visit
https://mail.gnome.org/mailman/listinfo/gnumeric-list
or, via email, send a message with subject or body 'help' to
gnumeric-list-request gnome org
You can reach the person managing the list at
gnumeric-list-owner gnome org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnumeric-list digest..."
Today's Topics:
1. Re: index-match functions problem; spreadsheet attached
(Morten Welinder)
----------------------------------------------------------------------
Message: 1
Date: Sun, 13 Dec 2015 18:05:40 -0500
From: Morten Welinder <mortenw gnome org>
To: George Dimitrov <gdparlichev gmail com>
Cc: Gnumeric Mailing List <gnumeric-list gnome org>
Subject: Re: index-match functions problem; spreadsheet attached
Message-ID:
<CANv4PNk_xsOONbqbAs-k=pd17SWzdaoXV3VV2Gsq6pROd+8KAA mail gmail com>
Content-Type: text/plain; charset=UTF-8
MATCH with types -1 and +1 requires sorted data. The data in, say,
A3:AW3 is
2 3 2 1 0 0 0 4 7 5 3 1 0 0 5 8 7 4 1 0 0 4 7 5 3 1 0 0 3 4 3 2 1 0 0
1 2 2 1 0 0 0 1 1 1 0 0 0 0
Clearly not sorted. Also, the data isn't unique which raises the question
of which occurrence of the maximum you are after. (In this case there is
only one 8, so that problem doesn't arise.)
What you want is type 0: find the index of the first occurrence.
Morten
------------------------------
Subject: Digest Footer
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
------------------------------
End of gnumeric-list Digest, Vol 139, Issue 7
*********************************************