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.


Reply via email to