Please ignore the filename as written to the Dropbox server; I resolved
the #DIV/0! issue myself, but I did not edit the filename.
On 3/27/2019 4:07 PM, WA.TWORSX via AOL wrote:
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
Windows 10x64 Home on desktop PC.
____________________________________________
With reference to cell range $E$76:$T$76 (Bowler's Highest 15-Game
Average data), I want Calc to examine the numerical values and
identify which Bowler's Highest 15-Game Average score is the LARGEST
value:
1. display within cell $E$78 the name of the bowler that has the
LARGEST value found within $E$76:$T$76; i.e., 189.83 found in cell
M76 and correlation to cell M74.
2. display within cell $F$78 the name of the bowler that has the 2nd
LARGEST value found within $E$76:$T$76; i.e., 180.50 found in cell
E76 and correlation to cell E74.
3. display within cell $G$78 the name of the bowler that has the 3rd
LARGEST value found within $E$76:$T$76; i.e., 168.67 found in cell
P76 and correlation to cell P74.
4. display within cell $H$78 the name of the bowler that has the 4th
LARGEST value found within $E$76:$T$76; i.e., 155.67 found in cell
O76 and correlation to cell O74.
5. display within cell $I$78 the name of the bowler that has the 5th
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in cell
and correlation to cell L74.
In 5. above, it should read as:
"display within cell $I$78 the name of the bowler that has the 5th
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in *cell L76*
and correlation to cell L74."
