Spreadsheet: 33915d1230833365-couting-the-column-count-pivot-example
Sheet: Sheet1

Count of Total No Shares
Total No Shares | Total
10 | 7
15 | 6
16 | 1
18 | 2
20 | 26
22 | 2
23 | 3
24 | 2
25 | 18
26 | 5
27 | 1
29 | 1
30 | 55
31 | 1
32 | 2
34 | 1
35 | 15
36 | 6
37 | 3
39 | 2
40 | 109
41 | 3
42 | 4
44 | 7
45 | 28
46 | 2
47 | 2
48 | 5
49 | 3
50 | 126
51 | 2
52 | 2
53 | 1
54 | 4
55 | 44
56 | 3
57 | 3
58 | 5
59 | 1
60 | 166
61 | 4
62 | 3
63 | 1
64 | 8
65 | 35
66 | 4
67 | 3
68 | 4
69 | 3
70 | 136
71 | 2
72 | 5
73 | 2
74 | 11
75 | 47
76 | 3
77 | 1
78 | 4
79 | 4
80 | 171
81 | 4
82 | 6
84 | 7
85 | 21
86 | 9
87 | 5
88 | 5
89 | 2
90 | 147
91 | 2
92 | 4
93 | 2
94 | 9
95 | 35
96 | 3
98 | 7
99 | 2
100 | 246
101 | 2
102 | 4
103 | 1
104 | 13
105 | 28
106 | 2
107 | 1
108 | 6
109 | 1
110 | 127
111 | 3
112 | 3
113 | 1
114 | 5
115 | 19
116 | 3
117 | 3
118 | 3
119 | 3
120 | 113
122 | 1
123 | 1
124 | 10
125 | 37
126 | 1
128 | 3
129 | 6
130 | 88
131 | 1
133 | 2
134 | 3
135 | 17
137 | 1
138 | 3
139 | 2
140 | 92
141 | 1
142 | 4
143 | 2
144 | 5
145 | 11
146 | 1
147 | 2
148 | 5
149 | 2
150 | 118
152 | 1
154 | 6
155 | 10
158 | 3
159 | 2
160 | 72
161 | 1
162 | 3
164 | 6
165 | 9
166 | 3
168 | 2
169 | 1
170 | 51
171 | 1
172 | 1
175 | 13
178 | 3
179 | 2
180 | 49
181 | 5
182 | 5
183 | 2
184 | 3
185 | 16
186 | 2
188 | 3
189 | 3
190 | 38
192 | 2
194 | 2
195 | 8
196 | 2
198 | 1
199 | 1
200 | 142
201 | 1
202 | 3
203 | 1
204 | 1
205 | 7
206 | 1
207 | 3
208 | 1
210 | 34
214 | 1
215 | 19
216 | 2
217 | 2
218 | 1
220 | 33
222 | 2
224 | 2
225 | 8
228 | 1
230 | 25
232 | 2
234 | 2
235 | 6
236 | 2
237 | 1
238 | 3
240 | 28
242 | 1
244 | 2
245 | 9
248 | 1
250 | 63
251 | 1
252 | 3
254 | 2
255 | 6
256 | 1
259 | 1
260 | 29
262 | 1
265 | 4
266 | 1
268 | 1
269 | 1
270 | 25
272 | 3
273 | 2
275 | 8
276 | 1
280 | 17
282 | 1
285 | 1
288 | 6
290 | 18
292 | 1
295 | 5
296 | 1
298 | 2
300 | 94
305 | 2
308 | 5
310 | 11
311 | 1
312 | 2
313 | 2
315 | 6
320 | 16
321 | 1
324 | 1
325 | 3
327 | 1
330 | 10
331 | 1
332 | 1
335 | 2
336 | 1
338 | 1
339 | 1
340 | 11
342 | 2
345 | 2
350 | 32
355 | 3
358 | 5
360 | 10
361 | 1
362 | 1
363 | 1
364 | 1
365 | 1
366 | 1
367 | 2
370 | 8
372 | 2
375 | 4
380 | 7
382 | 3
384 | 1
387 | 1
388 | 2
390 | 7
395 | 1
400 | 77
402 | 2
404 | 1
405 | 3
410 | 7
415 | 2
420 | 11
422 | 1
424 | 1
425 | 1
426 | 1
428 | 1
430 | 4
435 | 1
436 | 1
438 | 2
440 | 12
441 | 1
448 | 1
450 | 11
454 | 1
455 | 2
456 | 3
459 | 1
460 | 4
465 | 2
466 | 1
469 | 1
470 | 11
475 | 1
478 | 2
480 | 6
485 | 1
488 | 1
490 | 10
500 | 45
505 | 1
508 | 1
510 | 1
511 | 1
513 | 1
515 | 1
520 | 4
525 | 2
528 | 1
530 | 5
534 | 3
535 | 3
539 | 1
540 | 3
544 | 1
546 | 2
550 | 11
552 | 1
560 | 5
564 | 1
569 | 1
570 | 3
572 | 1
575 | 2
580 | 5
590 | 5
600 | 52
601 | 1
606 | 1
610 | 1
612 | 1
620 | 4
624 | 1
625 | 3
630 | 4
632 | 1
635 | 1
640 | 3
645 | 1
646 | 1
650 | 6
660 | 1
665 | 2
670 | 1
680 | 5
682 | 2
688 | 1
690 | 2
692 | 2
700 | 29
715 | 2
720 | 4
723 | 1
725 | 2
730 | 4
733 | 1
734 | 1
740 | 1
741 | 1
745 | 1
750 | 4
758 | 1
760 | 2
766 | 1
775 | 1
776 | 1
780 | 2
790 | 2
800 | 28
810 | 2
815 | 1
820 | 2
830 | 1
834 | 1
850 | 6
855 | 1
860 | 2
866 | 1
870 | 1
872 | 1
875 | 2
880 | 1
882 | 1
890 | 1
892 | 1
900 | 6
904 | 1
930 | 1
932 | 1
935 | 1
940 | 1
950 | 3
955 | 1
969 | 1
975 | 2
985 | 1
1000 | 46
1010 | 1
1020 | 1
1022 | 1
1030 | 1
1033 | 1
1050 | 2
1054 | 1
1062 | 1
1064 | 1
1080 | 1
1086 | 1
1100 | 8
1105 | 1
1110 | 1
1114 | 1
1115 | 1
1120 | 1
1130 | 1
1148 | 1
1150 | 1
1152 | 1
1155 | 1
1160 | 1
1185 | 1
1200 | 13
1217 | 1
1220 | 2
1240 | 1
1244 | 1
1250 | 1
1265 | 1
1282 | 1
1300 | 5
1301 | 1
1350 | 2
1352 | 2
1400 | 5
1420 | 1
1440 | 2
1450 | 1
1472 | 1
1500 | 15
1520 | 1
1530 | 1
1533 | 1
1538 | 4
1561 | 1
1570 | 1
1574 | 1
1600 | 9
1626 | 1
1690 | 1
1700 | 1
1710 | 1
1724 | 1
1740 | 1
1750 | 2
1800 | 5
1803 | 1
1825 | 1
1848 | 1
1900 | 2
1950 | 1
1952 | 1
1982 | 1
1985 | 1
2000 | 16
2070 | 1
2100 | 2
2200 | 1
2289 | 1
2290 | 1
2300 | 3
2310 | 1
2350 | 2
2490 | 1
2500 | 5
2505 | 1
2600 | 4
2620 | 1
2700 | 2
2736 | 1
2944 | 1
2960 | 1
3000 | 10
3080 | 1
3200 | 2
3250 | 2
3270 | 1
3310 | 1
3330 | 1
3400 | 2
3500 | 2
3595 | 1
3600 | 1
3628 | 1
3770 | 1
4000 | 4
4042 | 1
4180 | 1
4270 | 1
4300 | 1
4788 | 1
5000 | 3
5185 | 1
5380 | 1
6000 | 5
6055 | 1
6156 | 3
6239 | 1
6400 | 1
7000 | 2
7360 | 1
8000 | 1
8040 | 1
8445 | 1
10000 | 1
11560 | 1
13310 | 1
13500 | 1
13847 | 1
23255 | 1
23640 | 1
50000 | 1
55300 | 1
58500 | 1
72500 | 1
74192 | 1
100000 | 1
103517 | 1
110000 | 1
112324 | 1
115000 | 1
127096 | 1
136810 | 1
160594 | 1
175000 | 1
262173 | 1
348710 | 1
650912 | 1
700000 | 1
1500000 | 1
Grand Total | 4393