I have this table were has multipal values of a record, so need to find out onln the high value from the col name "sample_count" is there a vba or a formual to do it, i tried using maxfis but no luck.
also sharing the samble data as well.
also sharing the samble data as well.
Test.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | aggregate_date | place_name | region | place_type | isp_name | aggregation_period | platform | test_count | sample_count | Result | ||
2 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 51 | 23 | |||
3 | 1-Aug-23 | Saudi Arabia | country | GO Telecom | Month | Fiber | 74 | 68 | ||||
4 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | Salam | Month | Fiber | 27 | 19 | |||
5 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 4 | 4 | |||
6 | 1-Aug-23 | Saudi Arabia | country | stc | Month | All Fixed | 10 | 7 | Do not include | |||
7 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 2 | 2 | |||
8 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | stc | Month | All Fixed | 10 | 7 | Do not include | ||
9 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | stc | Month | All Fixed | 2 | 2 | Do not include | ||
10 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | Salam | Month | Fiber | 53 | 13 | |||
11 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 2 | 1 | |||
12 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 47 | 42 | |||
13 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | Salam | Month | Fiber | 2 | 1 | |||
14 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 15 | 15 | |||
15 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 82 | 14 | |||
16 | 1-Aug-23 | Saudi Arabia | country | stc | Month | All Fixed | 2 | 2 | Do not include | |||
17 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 3 | 3 | |||
18 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | Mobily | Month | All Fixed | 72 | 30 | |||
19 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | Salam | Month | All Fixed | 8 | 6 | |||
20 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 23 | 10 | |||
21 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | Salam | Month | All Fixed | 41 | 22 | |||
22 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 2406 | 776 | |||
23 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | Salam | Month | All Fixed | 347 | 129 | |||
24 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 261 | 132 | |||
25 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 253 | 91 | |||
26 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | Salam | Month | All Fixed | 582 | 216 | |||
27 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 946 | 270 | |||
28 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 131 | 24 | |||
29 | 1-Aug-23 | Saudi Arabia | country | GO Telecom | Month | All Fixed | 19534 | 5800 | ||||
30 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 18 | 10 | |||
31 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 3772 | 1284 | include | ||
32 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | Salam | Month | Fiber | 583 | 152 | |||
33 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 8571 | 2950 | |||
34 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | Salam | Month | All Fixed | 9697 | 3384 | |||
35 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | Mobily | Month | All Fixed | 153 | 51 | |||
36 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | Salam | Month | All Fixed | 26030 | 7841 | |||
37 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | Salam | Month | Fiber | 21877 | 6574 | |||
38 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | Zain | Month | All Fixed | 67989 | 13305 | |||
39 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | Salam | Month | All Fixed | 1063 | 319 | |||
40 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | Salam | Month | Fiber | 132 | 46 | |||
41 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | Zain | Month | All Fixed | 3514 | 847 | |||
42 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | Salam | Month | All Fixed | 235 | 88 | |||
43 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | Mobily | Month | All Fixed | 210 | 54 | |||
44 | 1-Aug-23 | Saudi Arabia | country | Salam | Month | All Fixed | 98770 | 31859 | ||||
45 | 1-Aug-23 | Saudi Arabia | country | Salam | Month | Fiber | 28019 | 8669 | ||||
46 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 1357 | 167 | |||
47 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | Zain | Month | All Fixed | 4570 | 1109 | |||
48 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | stc | Month | All Fixed | 31595 | 10107 | |||
49 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | Salam | Month | Fiber | 146 | 51 | |||
50 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | Salam | Month | All Fixed | 321 | 83 | |||
51 | 1-Aug-23 | Saudi Arabia | country | stc | Month | All Fixed | 1033229 | 288884 | include | |||
52 | 1-Aug-23 | Saudi Arabia | country | stc | Month | Fiber | 664190 | 204975 | include | |||
53 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | Zain | Month | All Fixed | 2056 | 439 | |||
54 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | stc | Month | All Fixed | 5004 | 1439 | |||
55 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | stc | Month | Fiber | 3010 | 778 | |||
56 | 1-Aug-23 | Al Jowf Province | Al Jowf Province | administrative_area_level_1 | Mobily | Month | All Fixed | 480 | 173 | |||
57 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | stc | Month | Fiber | 24920 | 7763 | |||
58 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | Mobily | Month | All Fixed | 1629 | 577 | |||
59 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | stc | Month | All Fixed | 14818 | 4136 | |||
60 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | Zain | Month | All Fixed | 8213 | 1873 | |||
61 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | stc | Month | All Fixed | 28841 | 10533 | |||
62 | 1-Aug-23 | Saudi Arabia | country | Zain | Month | All Fixed | 313284 | 71872 | ||||
63 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | stc | Month | All Fixed | 4092 | 1247 | |||
64 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | stc | Month | Fiber | 2903 | 831 | |||
65 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | Mobily | Month | All Fixed | 332 | 109 | |||
66 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | stc | Month | All Fixed | 172821 | 51776 | |||
67 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | stc | Month | Fiber | 126392 | 38026 | |||
68 | 1-Aug-23 | Eastern Province | Eastern Province | administrative_area_level_1 | Mobily | Month | All Fixed | 38308 | 11061 | |||
69 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | stc | Month | Fiber | 8653 | 2565 | |||
70 | 1-Aug-23 | Tabuk Province | Tabuk Province | administrative_area_level_1 | Mobily | Month | All Fixed | 2504 | 727 | |||
71 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | stc | Month | Fiber | 10522 | 3761 | |||
72 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | Mobily | Month | All Fixed | 2219 | 740 | |||
73 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | Salam | Month | All Fixed | 413 | 96 | |||
74 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | Salam | Month | Fiber | 321 | 83 | |||
75 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | Zain | Month | All Fixed | 1761 | 386 | |||
76 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | stc | Month | All Fixed | 286598 | 85591 | |||
77 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | stc | Month | Fiber | 168998 | 53432 | |||
78 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | Mobily | Month | All Fixed | 87770 | 25657 | |||
79 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | Salam | Month | All Fixed | 2487 | 780 | |||
80 | 1-Aug-23 | Al Qassim Province | Al Qassim Province | administrative_area_level_1 | Zain | Month | All Fixed | 1005 | 380 | |||
81 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 1276 | 315 | |||
82 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | Zain | Month | All Fixed | 890 | 196 | |||
83 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | stc | Month | All Fixed | 7658 | 3032 | |||
84 | 1-Aug-23 | Najran Province | Najran Province | administrative_area_level_1 | stc | Month | Fiber | 2647 | 859 | |||
85 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | Zain | Month | All Fixed | 851 | 216 | |||
86 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | stc | Month | All Fixed | 4820 | 1519 | |||
87 | 1-Aug-23 | Al Bahah Province | Al Bahah Province | administrative_area_level_1 | stc | Month | Fiber | 1826 | 600 | |||
88 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | Zain | Month | All Fixed | 102761 | 22730 | |||
89 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | stc | Month | All Fixed | 7931 | 2239 | |||
90 | 1-Aug-23 | Hail Province | Hail Province | administrative_area_level_1 | stc | Month | Fiber | 5233 | 1368 | |||
91 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | Salam | Month | All Fixed | 5225 | 1674 | |||
92 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | Zain | Month | All Fixed | 14905 | 4223 | |||
93 | 1-Aug-23 | Saudi Arabia | country | Mobily | Month | All Fixed | 187472 | 55819 | ||||
94 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | Zain | Month | All Fixed | 5408 | 1161 | |||
95 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | stc | Month | All Fixed | 40099 | 9178 | |||
96 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | stc | Month | Fiber | 15677 | 3723 | |||
97 | 1-Aug-23 | Jazan Province | Jazan Province | administrative_area_level_1 | Mobily | Month | All Fixed | 1682 | 448 | |||
98 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | Salam | Month | Fiber | 4878 | 1745 | |||
99 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | stc | Month | All Fixed | 360575 | 96622 | |||
100 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | stc | Month | Fiber | 247390 | 77644 | |||
101 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | Mobily | Month | All Fixed | 49195 | 15356 | |||
102 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | stc | Month | All Fixed | 60478 | 19449 | |||
103 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | stc | Month | Fiber | 45945 | 15834 | |||
104 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | Mobily | Month | All Fixed | 2644 | 1067 | |||
105 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | Salam | Month | All Fixed | 51822 | 17371 | |||
106 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | Zain | Month | All Fixed | 99219 | 26905 | |||
107 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 2 | 2 | |||
108 | 1-Aug-23 | Riyadh Province | Riyadh Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 43 | 38 | |||
109 | 1-Aug-23 | Al Madinah Province | Al Madinah Province | administrative_area_level_1 | GO Telecom | Month | Fiber | 3 | 3 | |||
110 | 1-Aug-23 | Makkah Province | Makkah Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 3637 | 1242 | Do not include | ||
111 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | Salam | Month | All Fixed | 555 | 209 | Do not include | ||
112 | 1-Aug-23 | Aseer Province | Aseer Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 906 | 257 | Do not include | ||
113 | 1-Aug-23 | Northern Borders Province | Northern Borders Province | administrative_area_level_1 | GO Telecom | Month | All Fixed | 17 | 9 | Do not include | ||
Sheet1 |