Spreadsheet: 47592d1246648042-how-do-i-get-percentages-for-a-column-example
Sheet: Sheet1

2345 | 44.19
2346 | 41.11
2347 | 45.98
2348 | 45.96
2349 | 46.45
2356 | 46.39
2357 | 45.23
2358 | 45.53
2359 | 44.81
2367 | 44.83
2368 | 44.69
2369 | 45.2
2378 | 52.75
2379 | 52.31
2389 | 52.55
2456 | 51.63
2457 | 52.37
2458 | 52.12
2459 | 50.79
2467 | 51.22
2468 | 50.92
2469 | 51.22
2478 | 53.55
2479 | 54.26
2489 | 53.88
2567 | 53.6
2568 | 47.28
2569 | 53.21
2578 | 53.95
2579 | 52.02
2589 | 51.99
2678 | 52.81
2679 | 52.27
2689 | 54.49
2789 | 54.42
3456 | 55.21
3457 | 54.7
3458 | 52.49
3459 | 54.6
3467 | 54.61
3468 | 53.9
3469 | 54.83
3478 | 54.29
3479 | 54.18
3489 | 52.29
3567 | 53.12
3568 | 53.13
3569 | 52.39
3578 | 55
3579 | 55.45
3589 | 55.27
3678 | 54.65
3679 | 52.92
3689 | 55.34
3789 | 55.72
4567 | 56.63
4568 | 55.08
4569 | 53.21
4578 | 53.2
4579 | 55.27
4589 | 55.15
4678 | 55.42
4679 | 56.06
4689 | 55.79
4789 | 55.52
5678 | 52.99
5679 | 53.84
5689 | 53.83
5789 | 53.73
6789 | 55.41
234J | 56.04
234K | 55.74
234Q | 56.06
234T | 53.77
235J | 55.55
235K | 56.11
235Q | 57.05
235T | 56.4
236J | 53.96
236K | 53.84
236Q | 55.23
236T | 56.67
237J | 57.72
237K | 55.83
237Q | 53.37
237T | 53.23
238J | 53.74
238K | 55.79
238Q | 55.63
238T | 55.98
239J | 56.58
239K | 56.3
239Q | 56.05
239T | 53.49
23JK | 53.54
23JQ | 53.56
23QK | 53.5
23TJ | 55.91
23TK | 55.76
23TQ | 55.42
245J | 55.96
245K | 53.57
245Q | 56.01
245T | 55.74
246J | 56.89
246K | 56.03
246Q | 53.62
246T | 53.66
247J | 55.73
247K | 56.45
247Q | 57.46
247T | 55.53
248J | 53.19
248K | 53.25
248Q | 53.82
248T | 56.01
249J | 57.65
249K | 58.69
249Q | 56.81
249T | 53.57
24JK | 53.34
24JQ | 53.96
24QK | 53.86
24TJ | 56.3
24TK | 56.01
24TQ | 56.21
256J | 57.01
256K | 56.6
256Q | 56.4
256T | 53.84
257J | 53.93
257K | 53.82
257Q | 54.01
257T | 55.66
258J | 55.35
258K | 54.92
258Q | 55.58
258T | 54.01
259J | 56.02
259K | 55.43
259Q | 56.53
259T | 55.99
25JK | 54.04
25JQ | 53.26
25QK | 55.59
25TJ | 56.18
25TK | 57.3
25TQ | 55.32
267J | 53.6
267K | 52.78
267Q | 53.65
267T | 55.75
268J | 57.54
268K | 58.57
268Q | 56.61
268T | 53.92
269J | 52.86
269K | 53.83
269Q | 53.78
269T | 56.07
26JK | 57.82
26JQ | 58.73
26QK | 56.91
26TJ | 53.56
26TK | 52.22
26TQ | 53.18
278J | 53.43
278K | 53.84
278Q | 56.42
278T | 56.18
279J | 56.59
279K | 57.23
279Q | 56.82
279T | 56.61
27JK | 54.1
27JQ | 54.15
27QK | 54.11
27TJ | 54.08
27TK | 55.78
27TQ | 55.63
289J | 55.19
289K | 55.84
289Q | 54.22
289T | 55.42
28JK | 55.03
28JQ | 56.06
28QK | 55.41
28TJ | 53.65
28TK | 53.51
28TQ | 55.2
29JK | 55.89
29JQ | 56.89
29QK | 54.8
29TJ | 53.24
29TK | 53.04
29TQ | 53.01
2JQK | 55.47
2TJK | 57.19
2TJQ | 58.22
2TQK | 56.14
345J | 53.63
345K | 53.15
345Q | 53.42
345T | 53.76
346J | 55.8
346K | 57.48
346Q | 58.57
346T | 56.64
347J | 53.2
347K | 52.48
347Q | 52.69
347T | 53.23
348J | 53.84
348K | 55.92
348Q | 57.62
348T | 58.64
349J | 56.69
349K | 53.32
349Q | 51.87
349T | 52.15
34JK | 52.67
34JQ | 53.26
34QK | 53.2
34TJ | 43.93
34TK | 42.61
34TQ | 43.67
356J | 43.53
356K | 43.87
356Q | 42.84
356T | 43.5
357J | 43.3
357K | 42.32
357Q | 42.72
357T | 41.38
358J | 43.32
358K | 42.51
358Q | 43.11
358T | 42.99
359J | 41.82
359K | 43.27
359Q | 42.54
359T | 41.35
35JK | 42.6
35JQ | 40.89
35QK | 42.55
35TJ | 41.48
35TK | 42.81
35TQ | 46.9
367J | 47.47
367K | 46.63
367Q | 47.33
367T | 46.86
368J | 47.58
368K | 44.44
368Q | 45.29
368T | 46.06
369J | 45.07
369K | 42.64
369Q | 41.13
369T | 41.89
36JK | 42.16
36JQ | 41.05
36QK | 41.66
36TJ | 39.9
36TK | 42.18
36TQ | 40.74
378J | 41.4
378K | 47.15
378Q | 46.93
378T | 46.02
379J | 47.39
379K | 46.77
379Q | 46.63
379T | 44.33
37JK | 45.62
37JQ | 45.44
37QK | 44.55
37TJ | 48.05
37TK | 49.09
37TQ | 47.32
389J | 49.47
389K | 47.6
389Q | 48.72
389T | 45.9
38JK | 46.56
38JQ | 47.63
38QK | 45.92
38TJ | 46.39
38TK | 47.06
38TQ | 47.86
39JK | 46.43
39JQ | 41.55
39QK | 40.85
39TJ | 41.56
39TK | 41.96
39TQ | 39.81
3JQK | 40.42
3TJK | 39.28
3TJQ | 41.23
3TQK | 40.41
456J | 40.99
456K | 46.2
456Q | 46.11
456T | 45.77
457J | 46.63
457K | 46.76
457Q | 46.67
457T | 43.62
458J | 44.96
458K | 44.9
458Q | 44.6
458T | 47.12
459J | 48.3
459K | 47.16
459Q | 48.96
459T | 47.8
45JK | 48.91
45JQ | 45.38
45QK | 46.03
45TJ | 47.07
45TK | 45.98
45TQ | 46.04
467J | 46.68
467K | 47.67
467Q | 46.9
467T | 48.75
468J | 49.08
468K | 47.64
468Q | 50.5
468T | 49.44
469J | 49.57
469K | 46
469Q | 47.5
469T | 47.81
46JK | 46.67
46JQ | 46.87
46QK | 48.35
46TJ | 48.2
46TK | 47.27
46TQ | 46.55
478J | 47.87
478K | 49.17
478Q | 47.04
478T | 40.58
479J | 41.37
479K | 41.17
479Q | 39.48
479T | 40.09
47JK | 39.01
47QK | 39.85
47TJ | 39.17
47TK | 39.92
47TQ | 46.2
489J | 46.07
489K | 45.78
489Q | 45.96
489T | 46.2
48JK | 46.09
48JQ | 43.42
[NAME] | 44.3
48TJ | 44.16
48TK | 43.85
48TQ | 47.18
49JK | 48.43
49JQ | 47.37
49QK | 48.25
49TJ | 48.48
49TK | 45.18
49TQ | 45.21
4JQK | 46.41
4TJK | 45.44
4TJQ | 46.3
567J | 46.36
567K | 47.39
567Q | 46.72
567T | 48.79
568J | 49.13
568K | 47.85
568Q | 50.01
568T | 48.92
569J | 49.02
569K | 45.96
569Q | 46.79
569T | 47.24
56JK | 45.88
56JQ | 47.34
56QK | 48.06
56TJ | 47.85
56TK | 47.07
56TQ | 47.06
578J | 47.69
578K | 48.99
578Q | 46.75
578T | 49.39
579J | 49.49
579K | 49.11
579Q | 51.12
579T | 50.12
57JK | 50.14
57JQ | 46.29
57QK | 47.4
57TJ | 47.54
57TK | 47.05
57TQ | 47.43
589J | 48.38
589K | 48
589Q | 48.2
589T | 47.32
58JK | 47.8
58JQ | 49.11
58QK | 48
58TJ | 46.88
58TK | 48.66
58TQ | 49.99
59JK | 47.65
59JQ | 40.89
59QK | 40.43
59TJ | 41.15
59TK | 41.51
59TQ | 39.33
5JQK | 39.84
5TJK | 38.66
5TJQ | 39.63
5TQK | 39.15
678J | 39.75
678K | 45.47
678Q | 45.39
678T | 45.13
679J | 45.2
679K | 45.53
679Q | 45.41
679T | 43.45
67JK | 44.25
67JQ | 44.12
67QK | 43.87
67TJ | 46.82
67TK | 47.9
67TQ | 46.87
689J | 47.83
689K | 46.82
689Q | 47.97
689T | 45.09
68JK | 45.32
68JQ | 46.54
68QK | 45.53
68TJ | 45.74
68TK | 45.79
68TQ | 46.75
69JK | 46.03
69JQ | 48.37
69QK | 48.76
69TJ | 47.42
69TK | 49.62
69TQ | 48.4
6JQK | 48.47
6TJK | 46.08
6TJQ | 46.92
6TQK | 47.38
789J | 46.04
789K | 46.67
789Q | 47.38
789T | 47.17
78JK | 46.48
78JQ | 46.81
78QK | 47.35
78TJ | 48.67
78TK | 46.36
78TQ | 48.85
79JK | 48.92
79JQ | 48.67
79QK | 50.69
79TJ | 49.7
79TK | 49.78
79TQ | 46.54
7JQK | 47.71
7TJK | 47.68
7TJQ | 47.15
[NAME] | 46.86
89JK | 47.7
89JQ | 47.36
89QK | 47.65
89TJ | 46.93
89TK | 47.49
89TQ | 48.81
8JQK | 47.7
8TJK | 46.73
8TJQ | 48.55
8TQK | 49.9
[NAME] | 47.45
[NAME] | 49.23
9TJQ | 49.28
9TQK | 49.03
A234 | 51.03
A235 | 50.07
A236 | 50.18
A237 | 46.9
A238 | 47.21
A239 | 47.47
A23J | 47.12
[NAME] | 47.27
A23Q | 47.3
A23T | 46.94
A245 | 47.45
A246 | 47.19
A247 | 46.97
A248 | 48.4
A249 | 47.51
A24J | 47.09
A24K | 48.18
A24Q | 49.5
A24T | 46.99
A256 | 46.99
A257 | 49.06
A258 | 50.32
A259 | 47.96
A25J | 40.71
A25K | 40.23
A25Q | 40.95
A25T | 41.2
A267 | 39.03
A268 | 39.78
A269 | 38.38
A26J | 39.46
A26K | 38.83
A26Q | 39.46
A26T | 45.68
A278 | 45.44
A279 | 45.18
A27J | 45.26
A27K | 45.63
A27Q | 45.39
A27T | 43.47
A289 | 44.53
A28J | 44.25
A28K | 43.97
A28Q | 46.01
A28T | 47.29
A29J | 46.25
A29K | 47.05
A29Q | 45.95
A29T | 47.24
A2JK | 44.49
A2JQ | 44.8
A2QK | 45.89
[NAME] | 44.85
A2TK | 45.83
A2TQ | 45.86
A345 | 46.98
A346 | 46.22
A347 | 48.01
A348 | 48.19
A349 | 47.02
A34J | 49.03
A34K | 47.97
A34Q | 47.99
A34T | 45.69
A356 | 46.54
A357 | 46.88
A358 | 45.65
A359 | 46.82
[NAME] | 47.58
[NAME] | 47.38
[NAME] | 46.62
[NAME]T | 46.04
A367 | 46.72
A368 | 48.02
A369 | 45.8
A36J | 48.35
[NAME] | 48.48
A36Q | 48.2
A36T | 50.26
A378 | 49.29
A379 | 49.22
A37J | 45.97
A37K | 47.17
A37Q | 47.4
A37T | 46.88
A389 | 47.07
A38J | 47.99
[NAME] | 47.39
A38Q | 47.86
A38T | 46.14
A39J | 46.79
A39K | 48.27
A39Q | 47.06
A39T | 46.39
A3JK | 48.3
A3JQ | 49.57
A3QK | 47.14
A3TJ | 48.81
A3TK | 48.93
A3TQ | 48.69
A456 | 50.77
A457 | 49.62
A458 | 49.77
A459 | 46.51
A45J | 46.78
A45K | 46.78
A45Q | 46.67
A45T | 47.47
A467 | 47.47
A468 | 46.95
A469 | 47.57
A46J | 46.8
A46K | 46.43
A46Q | 47.8
A46T | 46.85
A478 | 46.83
A479 | 47.92
A47J | 49.2
A47K | 46.71
A47Q | 46.86
A47T | 48.89
A489 | 50.22
A48J | 47.77
A48K | 49.18
A48Q | 49.23
A48T | 49.04
A49J | 50.9
A49K | 49.98
A49Q | 50.1
A49T | 46.76
A4JK | 47.07
A4JQ | 47.14
A4QK | 46.91
A4TJ | 47.13
A4TK | 47.12
[NAME] | 46.61
A567 | 47.12
A568 | 46.44
A569 | 46.06
A56J | 47.39
[NAME] | 46.26
A56Q | 46.5
[NAME]T | 47.52
A578 | 49
A579 | 46.37
A57J | 46.57
A57K | 48.73
A57Q | 49.98
A57T | 47.51
A589 | 46.8
A58J | 48.96
A58K | 50.24
A58Q | 47.79
A58T | 45.68
A59J | 45.76
A59K | 46.77
A59Q | 46.49
A59T | 46.05
A5JK | 45.32
A5JQ | 46.44
[NAME] | 46.33
A5TJ | 46.22
A5TK | 46.92
A5TQ | 46.86
A678 | 46.8
A679 | 46.59
A67J | 46.48
A67K | 46.67
A67Q | 45.06
A67T | 46.29
A689 | 46.61
A68J | 45.95
A68K | 46.87
A68Q | 47.18
A68T | 46.57
A69J | 47.03
A69K | 46.13
A69Q | 46.87
A69T | 46.46
A6JK | 46.55
A6JQ | 46.22
A6QK | 46.57
[NAME] | 46.19
A6TK | 46.77
A6TQ | 46.46
A789 | 45.67
A78J | 46.47
A78K | 46.67
[NAME] | 45.33
A78T | 46.37
A79J | 45.78
[NAME] | 45.73
A79Q | 47.06
A79T | 46.47
A7JK | 46.36
A7JQ | 46.7
A7JQ | 46.47
A7QK | 46.45
[NAME] | 46.67
A7TK | 46.07
A7TQ | 46.28
A89J | 46.28
A89K | 46.28
A89Q | 46.31
A89T | 46.27
A8JK | 46.07
A8JQ | 46.32
A8QK | 46.85
[NAME] | 46.97
A8TK | 46.33
A8TQ | 45.63
A9JK | 46.52
A9JQ | 45.82
A9QK | 46.02
A9TJ | 46.72
A9TK | 45.53
A9TQ | 46.16
AJQK | 46.84
ATJK | 46.09
ATJQ | 44.83
ATQK | 45.32
ATQK | 46.09
TJQK | 46.24