Spreadsheet: 884418d1733552747-best-to-the-left-array-lambda-map-sortby-recursive-sortby_rowid_explanation
Sheet: Sheet1

Name | Quota | No |  | The Problem - BestToTheLeft |  |  |  |  |  |  |  |  |  |  | When the logical_test argument of IF receives
Jacobs | 16.2 | 1 |  |  | Arrange each row of players, left to right, higher quota to left. |  |  |  |  |  |  |  |  |  | an array object (e.g. {1} or {TRUE}), all three
Hennessey | 18.8 | 2 |  |  | I want an array that I can paste Values over the first array. |  |  |  |  |  |  |  |  |  | arguments are automatically resized via
Wasson | 20.4 | 3 |  |  | So the better Quota Players on the Left, in Player A column |  |  |  |  |  |  |  |  |  | broadcasting. Since 1 is interpreted as TRUE,
Dieruf | 18 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | only the value_if_true argument is returned.
Morehead | 19.8 | 5 |  | RowID | Player A | Player B | Player C | Player D |  | Highest | Quota | To | Lowest
Yaden | 26.4 | 6 |  |  | Jacobs | Hennessey | Wasson | Open |  |  | Hennessey | Jacobs | Open |  |  | 1 | 1 | 1 |  |  | Hennessey | Jacobs | Open
[NAME] | 22.4 | 7 |  | 2 | Dieruf | Morehead | Yaden | [NAME] |  | Yaden | [NAME] | Morehead | Dieruf |  | 2 | 2 | 2 | 2 |  | Yaden | [NAME] | Morehead | Dieruf
[NAME] | 14 | 8 |  | 3 | [NAME] | Nalley | Garrett | [NAME] |  | Garrett | [NAME] | Nalley | [NAME] |  | 3 | 3 | 3 | 3 |  | Garrett | [NAME] | Nalley | [NAME]
Nalley | 19.8 | 9 |  | 4 | Dietz | Wachtel | Abell | Barnes |  | Wachtel | Abell | Dietz | Barnes |  | 4 | 4 | 4 | 4 |  | Wachtel | Abell | Dietz | Barnes
Garrett | 28.8 | 10 |  | 5 | Ruffra | O'Neil | [NAME] | Clem |  | Clem | Ruffra | O'Neil | [NAME] |  | 5 | 5 | 5 | 5 |  | Clem | Ruffra | O'Neil | [NAME]
[NAME] | 25.4 | 11 |  | 6 | Walsh | Pribble | Blandford | [NAME] |  | Blandford | Walsh | Pribble | [NAME] |  | 6 | 6 | 6 | 6 |  | Blandford | Walsh | Pribble | [NAME]
Dietz | 20.2 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | ↓ |  |  |  |  | ↑
Wachtel | 32.4 | 13 |  |  | I'm first using a [NAME] funtion in F15 to get an array of Quotas |  |  |  |  |  |  |  |  |  | ↓ | Name | RowID | Quota |  | ↑ | Name | RowID | Quota
Abell | 24.6 | 14 |  |  |  | 18.8 | 20.4 | 0 |  |  | 18.8 | 20.4 | 0 | → → | TOCOL: |  | 1 | 16.2 | → → | [NAME]: |  | 1 | 20.4
Barnes | 17.6 | 15 |  |  | 18 | 19.8 | 26.4 | 22.4 |  | 18 | 19.8 | 26.4 | 22.4 |  |  | Hennessey | 1 | 18.8 |  |  | Hennessey | 1 | 18.8
Ruffra | 24.6 | 16 |  |  | 14 | 19.8 | 28.8 | 25.4 |  | 14 | 19.8 | 28.8 | 25.4 |  |  | Wasson | 1 | 20.4 |  |  | Jacobs | 1 | 16.2
O'Neil | 21 | 17 |  |  | 20.2 | 32.4 | 24.6 | 17.6 |  | 20.2 | 32.4 | 24.6 | 17.6 |  |  | Open | 1 | 0 |  |  | Open | 1 | 0
[NAME] | 20.4 | 18 |  |  | 24.6 | 21 | 20.4 | 30.4 |  | 24.6 | 21 | 20.4 | 30.4 |  |  | Dieruf | 2 | 18 |  |  | Yaden | 2 | 26.4
Clem | 30.4 | 19 |  |  | 26.8 | 26.8 | 27 | 10.6 |  | 26.8 | 26.8 | 27 | 10.6 |  |  | Morehead | 2 | 19.8 |  |  | [NAME] | 2 | 22.4
Walsh | 26.8 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yaden | 2 | 26.4 |  |  | Morehead | 2 | 19.8
Pribble | 26.8 | 21 |  |  | Then I use a SortBy to arrange the names based on Quota - Highest to Lowest |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 22.4 |  |  | Dieruf | 2 | 18
Blandford | 27 | 22 |  |  | But I need to do this for each individual ROW. |  |  |  |  | Validate Results: |  |  |  |  |  | [NAME] | 3 | 14 |  |  | Garrett | 3 | 28.8
[NAME] | 10.6 | 23 |  |  |  | Hennessey | Jacobs | Open |  |  | True | True | True |  |  | Nalley | 3 | 19.8 |  |  | [NAME] | 3 | 25.4
 |  |  |  |  |  | [NAME] | Morehead | Dieruf |  | True | True | True | True |  |  | Garrett | 3 | 28.8 |  |  | Nalley | 3 | 19.8
 |  |  |  |  |  | [NAME] | Nalley | [NAME] |  | True | True | True | True |  |  | [NAME] | 3 | 25.4 |  |  | [NAME] | 3 | 14
 |  |  |  |  |  | Abell | Dietz | Barnes |  | True | True | True | True |  |  | Dietz | 4 | 20.2 |  |  | Wachtel | 4 | 32.4
 |  |  |  |  |  | Ruffra | O'Neil | [NAME] |  | True | True | True | True |  |  | Wachtel | 4 | 32.4 |  |  | Abell | 4 | 24.6
 |  |  |  |  |  | Walsh | Pribble | [NAME] |  | True | True | True | True |  |  | Abell | 4 | 24.6 |  |  | Dietz | 4 | 20.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Barnes | 4 | 17.6 |  |  | Barnes | 4 | 17.6
 |  |  |  |  | Now I copy the last array and Paste Values over the first array.  Done. |  |  |  |  |  |  |  |  |  |  | Ruffra | 5 | 24.6 |  |  | Clem | 5 | 30.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O'Neil | 5 | 21 |  |  | Ruffra | 5 | 24.6
 |  |  |  |  | How can I create the last array  using a ByRow Function??? |  |  |  |  |  |  |  |  |  |  | [NAME] | 5 | 20.4 |  |  | O'Neil | 5 | 21
 |  |  |  |  | Better would be to not need intermediate arrays to do all the work? |  |  |  |  |  |  |  |  |  |  | Clem | 5 | 30.4 |  |  | [NAME] | 5 | 20.4
 |  |  |  |  |  | Not sure this is possible without a Recursive Lambda. |  |  |  |  |  |  |  |  |  | Walsh | 6 | 26.8 |  |  | Blandford | 6 | 27
 |  |  |  |  |  | I need a spill function in F24?? |  |  |  |  |  |  |  |  |  | Pribble | 6 | 26.8 |  |  | Walsh | 6 | 26.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blandford | 6 | 27 |  |  | Pribble | 6 | 26.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6 | 10.6 |  |  | [NAME] | 6 | 10.6