Martin: What is your point ? If you’re not that interested in offering assistance, please ignore my request(s) for help. Normally, I give thanks to (helpful) replies. Clearly, your reply is of no help to me.
Regards, Vince Sent from my iPad > On Mar 14, 2018, at 17:18, Martin Groenescheij <mar...@groenescheij.com> > wrote: > > 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 >