Dear Morten, I made corrections according to your suggestion, but the problem remains. Maybe I didn't apply the formula correctly. I just copied the formula from LibreOffice Calc to Gnumeric and applied your corrections. But maybe there's something else I don't understand - maybe in the numbervalue() function.
Best regards, George 2015-12-14 14:00 GMT+02:00 <[email protected]>: > Send gnumeric-list mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: George Dimitrov <[email protected]> > Cc: Gnumeric Mailing List <[email protected]> > Subject: Re: index-match functions problem; spreadsheet attached > Message-ID: > <CANv4PNk_xsOONbqbAs-k= > [email protected]> > 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 > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list > > > ------------------------------ > > End of gnumeric-list Digest, Vol 139, Issue 7 > ********************************************* >
_______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
