Spreadsheet: 538595d1505737251-when-sorting-a-table-the-sort-isnt-holding-example
Sheet: Z1 Q1_Q4

 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average |  | invert - 10 | percent *10
 | #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 |  |  |  | 10 | 10
1 | 5 | 9 | 7 | 9 | 7 | 9 | 7 | 9
2 | 3 | 7 | 5 | 9 | 5 | 9 | 5 | 9
3 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 5
4 | 6 | 1 | 4 | 1 | 4 | 1 | 4 | 1
5 | 8 | 7 | 3 | 3 | 3 | 3 | 3 | 3
6 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 6
7 | 6 | 1 | 5 | 6 | 5 | 6 | 5 | 6
8 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
9 | 7 | 3 | 9 | 3 | 7 | 3 | 9 | 3
10 | 9 | 7 | 5 | 9 | 5 | 9 | 5 | 9
11 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5
12 | 1 | 1 | 4 | 1 | 4 | 1 | 4 | 1
13 | 3 | 7 | 3 | 3 | 3 | 3 | 3 | 3
14 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #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
1 | 5 | 9 | 7 | 9 | 7 | 7 | 9 | 7 | 7 | 9 | 7
2 | 3 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
3 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
4 | 6 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
5 | 8 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
6 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
7 | 6 | 1 | 5 | 6 | 5 | 5 | 6 | 5 | 5 | 6 | 5
8 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1
9 | 7 | 3 | 9 | 3 | 7 | 7 | 3 | 9 | 7 | 3 | 9
10 | 9 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
11 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
12 | 1 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
13 | 3 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
14 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #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
1 | 5 | 9 | 7 | 9 | 7 | 7 | 9 | 7 | 7 | 9 | 7
2 | 3 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
3 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
4 | 6 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
5 | 8 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
6 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
7 | 6 | 1 | 5 | 6 | 5 | 5 | 6 | 5 | 5 | 6 | 5
8 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1
9 | 7 | 3 | 9 | 3 | 7 | 7 | 3 | 9 | 7 | 3 | 9
10 | 9 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
11 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
12 | 1 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
13 | 3 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
14 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Client Responses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average
 | #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
1 | 5 | 9 | 7 | 9 | 7 | 7 | 9 | 7 | 7 | 9 | 7
2 | 3 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
3 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
4 | 6 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
5 | 8 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
6 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
7 | 6 | 1 | 5 | 6 | 5 | 5 | 6 | 5 | 5 | 6 | 5
8 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1
9 | 7 | 3 | 9 | 3 | 7 | 7 | 3 | 9 | 7 | 3 | 9
10 | 9 | 7 | 5 | 9 | 5 | 5 | 9 | 5 | 5 | 9 | 5
11 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
12 | 1 | 1 | 4 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 4
13 | 3 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
14 | 5 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5