I AM TRYING TO ADD COLUMN “F” TO MY SPREADSHEET TO RECORD “BEST”RANK (COLUMN A) ACHIEVED AFTER SORTING. I SORT COLUMNS C-E, SORT BY MONEY, HIGHESTTO SMALLEST AS THE AMOUNT IN COLUMN D CHANGES.
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Thank you
Rich
A | B | C | D | E | F | |
1 | THIS WEEK | +/- | NAME | MONEY | LAST | BEST |
2 | 1 | 5 | A | $100 | 6 | 1 |
3 | 2 | 8 | F | $90 | 10 | 2 |
4 | 3 | -2 | I | $80 | 1 | 3 |
5 | 4 | -2 | C | $70 | 2 | 4 |
6 | 5 | -2 | E | $60 | 3 | 5 |
7 | 6 | -2 | D | $50 | 4 | 6 |
8 | 7 | -2 | B | $40 | 5 | 7 |
9 | 8 | -1 | J | $30 | 7 | 8 |
10 | 9 | -1 | H | $20 | 8 | 9 |
11 | 10 | -1 | G | $10 | 9 | 10 |
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Thank you
Rich