Spreadsheet: 884420d1733552853-best-to-the-left-array-lambda-map-sortby-recursive-sortby_birow_function
Sheet: Sheet1

Name | Quota | No |  | The Problem - BestToTheLeft
Jacobs | 16.2 | 1 |  |  | Arrange each row of players, left to right, higher quota to left.
Hennessey | 18.8 | 2 |  |  | I want an array that I can paste Values over the first array.
Wasson | 20.4 | 3 |  |  | So the better Quota Players on the Left, in Player A column
Dieruf | 18 | 4
Morehead | 19.8 | 5 |  |  | Player A | Player B | Player C | Player D
Yaden | 26.4 | 6 |  |  | Jacobs | Hennessey | Wasson | Open |  |  | Hennessey | Jacobs | Open |  |  | Hennessey | Jacobs | Open
[NAME] | 22.4 | 7 |  |  | Dieruf | Morehead | Yaden | [NAME] |  | Yaden | [NAME] | Morehead | Dieruf |  | Yaden | [NAME] | Morehead | Dieruf
[NAME] | 14 | 8 |  |  | [NAME] | Nalley | Garrett | [NAME] |  | Garrett | [NAME] | Nalley | [NAME] |  | Garrett | [NAME] | Nalley | [NAME]
Nalley | 19.8 | 9 |  |  | Dietz | Wachtel | Abell | Barnes |  | Wachtel | Abell | Dietz | Barnes |  | Wachtel | Abell | Dietz | Barnes
Garrett | 28.8 | 10 |  |  | Ruffra | O'Neil | [NAME] | Clem |  | Clem | Ruffra | O'Neil | [NAME] |  | Clem | Ruffra | O'Neil | [NAME]
[NAME] | 25.4 | 11 |  |  | Walsh | Pribble | Blandford | [NAME] |  | Blandford | Walsh | Pribble | [NAME] |  | 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 |  |  |  |  |  |  |  |  |  | Validate Results:
Abell | 24.6 | 14 |  |  |  | 18.8 | 20.4 | 0 |  |  | Hennessey | Jacobs | Open |  |  | True | True | True
Barnes | 17.6 | 15 |  |  | 18 | 19.8 | 26.4 | 22.4 |  | Yaden | [NAME] | Morehead | Dieruf |  | True | True | True | True
Ruffra | 24.6 | 16 |  |  | 14 | 19.8 | 28.8 | 25.4 |  | Garrett | [NAME] | Nalley | [NAME] |  | True | True | True | True
O'Neil | 21 | 17 |  |  | 20.2 | 32.4 | 24.6 | 17.6 |  | Wachtel | Abell | Dietz | Barnes |  | True | True | True | True
[NAME] | 20.4 | 18 |  |  | 24.6 | 21 | 20.4 | 30.4 |  | Clem | Ruffra | O'Neil | [NAME] |  | True | True | True | True
Clem | 30.4 | 19 |  |  | 26.8 | 26.8 | 27 | 10.6 |  | Blandford | Walsh | Pribble | [NAME] |  | True | True | True | True
Walsh | 26.8 | 20
Pribble | 26.8 | 21 |  |  | Then I use a SortBy to arrange the names based on Quota - Highest to Lowest
Blandford | 27 | 22 |  |  | But I need to do this for each individual ROW. |  |  |  |  | Validate Results:
[NAME] | 10.6 | 23 |  |  |  | Hennessey | Jacobs | Open |  |  | True | True | True
 |  |  |  |  |  | [NAME] | Morehead | Dieruf |  | True | True | True | True
 |  |  |  |  |  | [NAME] | Nalley | [NAME] |  | True | True | True | True
 |  |  |  |  |  | Abell | Dietz | Barnes |  | True | True | True | True
 |  |  |  |  |  | Ruffra | O'Neil | [NAME] |  | True | True | True | True
 |  |  |  |  |  | Walsh | Pribble | [NAME] |  | True | True | True | True
 |  |  |  |  | Now I copy the last array and Paste Values over the first array.  Done.
 |  |  |  |  | How can I create the last array  using a ByRow Function???
 |  |  |  |  | Better would be to not need intermediate arrays to do all the work?
 |  |  |  |  |  | Not sure this is possible without a Recursive Lambda.
 |  |  |  |  |  | I need a spill function in F24??