Max value with range

[vmjan02]

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.

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

 

[kvsrinivasamurthy]

What is the condition for "Do not include" rows.

 

[vmjan02]

with respect to placename, region, place type, isp name and platform