J
JAS
I need to rank total column from highest number to lowest
number in rank column without rearranging other columns:
Example:
Date CH EG WC WH Totals Rank
12/30 8 2 5 6 21
1/6 19 9 13 23 64
1/13 22 13 19 7 61
1/20 20 13 14 9 56
1/27 20 12 12 12 56
2/3 21 16 14 21 72
2/10 21 6 5 10 42
2/17 18 4 6 11 39
2/24 20 4 12 16 52
3/3 26 12 16 15 69
3/10 21 10 13 21 65
3/17 7 10 13 6 36
3/24 16 6 11 9 42
3/31 17 9 6 10 42
4/7 12 14 10 13 49
4/14 14 4 3 7 28
4/21 17 4 9 6 36
4/28 8 10 8 8 34
5/5 13 6 15 7 41
5/12 16 10 14 19 59
5/19 14 13 32 11 70
5/26 12 8 14 16 50
6/2 16 25 45 24 110
6/9 16 9 32 19 76
6/16 12 7 23 14 56
6/23 8 7 14 9 38
6/30 7 5 7 6 36
7/7 6 5 10 7 28
7/14 7 7 6 1 21
7/21 6 6 7 1 20
7/28 3 5 6 5 19
8/4 6 3 8 1 18
8/11 7 3 5 2 17
8/18 8 3 4 1 16
8/25 9 3 7 2 21
9/1 13 5 6 6 30
9/8 11 7 10 6 34
9/15 8 7 16 4 35
9/22 14 6 12 6 38
9/29 9 11 13 7 40
10/6 10 5 12 3 30
10/13 11 8 4 3 26
10/20 10 6 7 7 30
10/27 20 10 7 9 46
11/3 0
11/10 0
11/17 0
11/24 0
12/1 0
12/8 0
12/15 0
12/22 0
Totals: 579 348 525 406 1869
number in rank column without rearranging other columns:
Example:
Date CH EG WC WH Totals Rank
12/30 8 2 5 6 21
1/6 19 9 13 23 64
1/13 22 13 19 7 61
1/20 20 13 14 9 56
1/27 20 12 12 12 56
2/3 21 16 14 21 72
2/10 21 6 5 10 42
2/17 18 4 6 11 39
2/24 20 4 12 16 52
3/3 26 12 16 15 69
3/10 21 10 13 21 65
3/17 7 10 13 6 36
3/24 16 6 11 9 42
3/31 17 9 6 10 42
4/7 12 14 10 13 49
4/14 14 4 3 7 28
4/21 17 4 9 6 36
4/28 8 10 8 8 34
5/5 13 6 15 7 41
5/12 16 10 14 19 59
5/19 14 13 32 11 70
5/26 12 8 14 16 50
6/2 16 25 45 24 110
6/9 16 9 32 19 76
6/16 12 7 23 14 56
6/23 8 7 14 9 38
6/30 7 5 7 6 36
7/7 6 5 10 7 28
7/14 7 7 6 1 21
7/21 6 6 7 1 20
7/28 3 5 6 5 19
8/4 6 3 8 1 18
8/11 7 3 5 2 17
8/18 8 3 4 1 16
8/25 9 3 7 2 21
9/1 13 5 6 6 30
9/8 11 7 10 6 34
9/15 8 7 16 4 35
9/22 14 6 12 6 38
9/29 9 11 13 7 40
10/6 10 5 12 3 30
10/13 11 8 4 3 26
10/20 10 6 7 7 30
10/27 20 10 7 9 46
11/3 0
11/10 0
11/17 0
11/24 0
12/1 0
12/8 0
12/15 0
12/22 0
Totals: 579 348 525 406 1869