Hi Again:

Well, my previous posting failed, due to the formatting not being carried over in the post. Copy and Paste works okay with a YahooGroup Mailing List, but not here. So, I am making another attempt to present my question/problem, and ask for advice and assistance.

(I imagine that this problem is not unlike a sales manager ranking the performance of 13 salesmen during a specific period, nor is it unlike determining which of 13 factories produced the highest product output over a specific time period. I have read through Chapter 7 of the Calc vers 3 user's guide, but did not find a solution. Perhaps this problem could more easier be solved using AOO- Base, with which I am not experienced in using.)


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25  on WIN10-64 Desktop


I am working with a data set that, ultimately, at the end of a bowling tournament will show a collection of bowling scores. At present, there are 13 bowlers participating in the tournament, and that number might increase.

See this drop box link, which shows my work thus far:

https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0 .

Cells E25:T25 contain the names of the 13 bowlers.  Cells E33:T44 contain the numerical data of interest (i.e., scores gathered during the tournament's competition phase).

I used the =LARGE($E$33:$T$44;1) thru =LARGE($E$33:$T$44;9) to calculate the nine highest scores within the score data of interest; the results are shown in cells E9:E17. This will ultimately be expanded to include the 45 highest bowling scores with the identifying bowler's name for each (qualifying) score. (I have begun doing that in cells G9:I19.)

I need to correlate the BOWLER'S NAME with each of the HIGHEST SCORES, and fill in the BOWLER's NAME column (cells D9:D17;H9:H19, etc.).  E.g., POSITION 1 shows a score of 233 (in cell F35) and that was by bowler Bob M. (in cell F25).

Is there a Calc function that will "look up" the appropriate name in Row 25 for each of the remaining HIGHEST SCORES and display the result within the BOWLER's NAME columns?

Any suggestions shall be appreciated.



Reply via email to