Spreadsheet: 862593d1710270331-changing-values-in-a-column-based-on-the-position-of-x-in-a-grid-auto-dart-sample
Sheet: Sheet1

This chart allows you to find the average impact force needed to break plastic film.  To semi-automate this process I need help changing the values in a column based on the position of “X” in a grid. In column AS (Highlighted Area) I would like to enter a zero in the row with the lowest weight that has an “X”. Once the zero is entered in the row with the lowest weight I need the rows above the zero to increase by 1 until the column is full. (Rows below the zero can = zero or be left blank) Additionally, I would like the lowest weight value that has an “X” to appear in cell B4 (Also Highlighted).  I manually entered the values in column AS to show how it will look when completed.
Sum of column AT -> |  | Weight | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Sum of "X" in each row | HELP | Product
Sum of column AR -> |  | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Lowest weight that an "X" appears -> | 390 | 570 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Thickness -> | 0.83 | 540 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  | X |  |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Dart = |  | 510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  |  |  | X |  | O |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 480 |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 450 |  |  |  |  |  |  |  |  | X |  | X |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 420 |  | X |  |  |  | X |  | O |  | O |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 390 | O |  | X |  | O |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 360 |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 330 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 240 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0