You must be subscribed to the list. Please see the instructions at the bottom of each email in order to unsubscribe. If this fails then POLITELY ask for help.
We are all volunteers on this list please learn not to be a jerk as that will help you in life. Regards, Dave Sent from my iPhone > On Mar 14, 2018, at 3:06 PM, Daniels <rossn...@gotalk.net.au> wrote: > > WHY DOESN'T 'BLOCKING SENDER' WORK WITH YOU ON MY JUNK > MAIL?????????????????????????? > > > > -----Original Message----- From: Martin Groenescheij > Sent: Thursday, March 15, 2018 8:18 AM > To: users@openoffice.apache.org > Cc: mar...@groenescheij.com > Subject: Re: Need Formula to use with Results of LARGE( ) Function's Result- > Lookup? > > This is the fourth version of your problem. > Keep trying, if you don't succeed by version 21 I will have a look into > your question. > > >> On 15/03/18 3:29 AM, WA.TWORSX via AOL wrote: >> >> >> Hi Again: >> >> _____________________________________ >> >> AOO415m1(Build:9789) - Rev. 1817496 >> 2017-12-11 17:25 on WIN10-64 Desktop >> >> _____________________________________ >> >> I am still struggling with this project; and I do need and seek help, >> however! >> >> I have uploaded to DropBox an AOO-Calc spreadsheet file. Here is the shared >> link: >> https://www.dropbox.com/s/e84yntxyouf7if7/BVL%20Summary%20Trial%20Sheets%20%281%29.ods?dl=0 >> >> I draw your attention to Sheet 4 in the BVL Summary Trial Sheets(1).ods file: >> >> Note that cells E57:Q57 contain the names of 13 bowlers. The data displayed >> in cells E58:Q60 was calculated using the LARGE( ) function to obtain the >> game scores for each bowler. The data displayed within cells D75:F109 was >> calculated using the LARGE( ) function to obtain 35 bowling scores in >> decreasing order (“233” is the highest and “77” is the lowest). >> >> The task is to correlate the highest score (i.e., “233”, found in cell F75), >> and each score that follows in cells F76:F109, with the name of the bowler, >> that made the corresponding game score, (in this instance, Bob M., found in >> cell F57). I want to display the appropriate resulting bowler names within >> cells H75:H109. >> >> Is there an AOO-Calc formula/multiple functions that can be used to solve >> the task at hand? I have looked at the LOOKUP( ) and RANK( ) functions, >> but did not get very far. I am hoping that there is a way to match the >> bowlers' name with the corresponding game score. >> >> >> Regards, >> VinceB. >> >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
