Accept Max values

[vmjan02]

I have this data and have pasted in xl2bb sheet, and the concern is from the data it sould mention as "Do not include" in result coulmn. I tried many ways , like rank, match index and lot more dut non wokred.

idea is from very region, place type, isp name and platform it should only take the max number from sample_count and sound display Do not include for the low sample_count, not sure if the macor or a esxcel function will work.

any help willbe great. Ihave tried to explain it in the best way, it will be great to fig it out.

aggregate_date	place_name	region	place_type	isp_name	aggregation_period	platform	test_count	sample_count	Result
1-Aug-23​	Saudi Arabia		country	stc	Month	All Fixed	10​	7​	Do not include
1-Aug-23​	Saudi Arabia		country	stc	Month	All Fixed	2​	2​	Do not include
1-Aug-23​	Saudi Arabia		country	stc	Month	All Fixed	1033229​	288884​

aggregate_date	place_name	region	place_type	isp_name	aggregation_period	platform	test_count	sample_count	Result
1-Aug-23​	Aseer Province	Aseer Province	administrative_area_level_1	GO Telecom	Month	All Fixed	946​	270​
1-Aug-23​	Aseer Province	Aseer Province	administrative_area_level_1	GO Telecom	Month	All Fixed	906​	257​	Do not include

Test.xlsx
	A
1	aggregate_date
Sheet1

 

[vmjan02]

here you go,

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
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
52	1-Aug-23	Saudi Arabia		country	stc	Month	Fiber	664190	204975
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

 

[vmjan02]

hi every one any idea for this.

 

[vmjan02]

I have tried this code, but its not working as required

any other way for it.

sub text()
Dim zelle As Range
Dim rng As Range
Dim lCol As Long
Dim lLastRow As Long
  With ActiveSheet
    For lCol = 2 To .UsedRange.Columns.Count
      lLastRow = .Cells(.Rows.Count, lCol).End(xlUp).Row
      Set rng = .Range(.Cells(2, lCol), .Cells(lLastRow, lCol))
      For Each zelle In rng
        If zelle.Value = Application.WorksheetFunction.Max(rng) Then
          zelle.Interior.ColorIndex = 6
        Else
          zelle.Interior.ColorIndex = xlNone
        End If
      Next
    Next lCol
  End With
End Sub

 

[Armstrong_N14]

Hope this helps

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

Cell Formulas
Range	Formula
J2:J113	J2	=IF(MAXIFS($H$2:$H$113,$K$2:$K$113,K2)=H2,"","Do not include")
K2:K113	K2	=B2&C2&D2&E2&G2

 

[Peter_SSs]

Hope this helps

Not sure that it will since the OP's profile shows Excel 2013 which does not have MAXIFS.
However, here is another option but using functions for earlier versions and excluding the helper column.

vmjan02.xlsm
	C	D	E		G		I	J
1	region	place_type	isp_name		platform		sample_count	Result
2	Hail Province	administrative_area_level_1	GO Telecom		All Fixed		23
3		country	GO Telecom		Fiber		68
4	Tabuk Province	administrative_area_level_1	Salam		Fiber		19
5	Al Qassim Province	administrative_area_level_1	GO Telecom		Fiber		4
6		country	stc		All Fixed		7	Do not include
7	Makkah Province	administrative_area_level_1	GO Telecom		Fiber		2
8	Eastern Province	administrative_area_level_1	stc		All Fixed		7	Do not include
9	Eastern Province	administrative_area_level_1	stc		All Fixed		2	Do not include
10	Al Jowf Province	administrative_area_level_1	Salam		Fiber		13
11	Al Jowf Province	administrative_area_level_1	GO Telecom		Fiber		1
12	Riyadh Province	administrative_area_level_1	GO Telecom		Fiber		42
13	Makkah Province	administrative_area_level_1	Salam		Fiber		1
14	Eastern Province	administrative_area_level_1	GO Telecom		Fiber		15
15	Najran Province	administrative_area_level_1	GO Telecom		All Fixed		14
16		country	stc		All Fixed		2	Do not include
17	Al Madinah Province	administrative_area_level_1	GO Telecom		Fiber		3
18	Najran Province	administrative_area_level_1	Mobily		All Fixed		30
19	Al Bahah Province	administrative_area_level_1	Salam		All Fixed		6
20	Al Bahah Province	administrative_area_level_1	GO Telecom		All Fixed		10
21	Jazan Province	administrative_area_level_1	Salam		All Fixed		22
22	Eastern Province	administrative_area_level_1	GO Telecom		All Fixed		776
23	Tabuk Province	administrative_area_level_1	Salam		All Fixed		129
24	Tabuk Province	administrative_area_level_1	GO Telecom		All Fixed		132
25	Al Qassim Province	administrative_area_level_1	GO Telecom		All Fixed		91
26	Aseer Province	administrative_area_level_1	Salam		All Fixed		216
27	Aseer Province	administrative_area_level_1	GO Telecom		All Fixed		270
28	Al Jowf Province	administrative_area_level_1	GO Telecom		All Fixed		24
29		country	GO Telecom		All Fixed		5800
30	Northern Borders Province	administrative_area_level_1	GO Telecom		All Fixed		10
31	Makkah Province	administrative_area_level_1	GO Telecom		All Fixed		1284
32	Al Qassim Province	administrative_area_level_1	Salam		Fiber		152
33	Riyadh Province	administrative_area_level_1	GO Telecom		All Fixed		2950
34	Makkah Province	administrative_area_level_1	Salam		All Fixed		3384
35	Hail Province	administrative_area_level_1	Mobily		All Fixed		51
36	Eastern Province	administrative_area_level_1	Salam		All Fixed		7841
37	Eastern Province	administrative_area_level_1	Salam		Fiber		6574
38	Eastern Province	administrative_area_level_1	Zain		All Fixed		13305
39	Hail Province	administrative_area_level_1	Salam		All Fixed		319
40	Hail Province	administrative_area_level_1	Salam		Fiber		46
41	Hail Province	administrative_area_level_1	Zain		All Fixed		847
42	Najran Province	administrative_area_level_1	Salam		All Fixed		88
43	Al Bahah Province	administrative_area_level_1	Mobily		All Fixed		54
44		country	Salam		All Fixed		31859
45		country	Salam		Fiber		8669
46	Jazan Province	administrative_area_level_1	GO Telecom		All Fixed		167
47	Tabuk Province	administrative_area_level_1	Zain		All Fixed		1109
48	Al Qassim Province	administrative_area_level_1	stc		All Fixed		10107
49	Al Madinah Province	administrative_area_level_1	Salam		Fiber		51
50	Al Jowf Province	administrative_area_level_1	Salam		All Fixed		83
51		country	stc		All Fixed		288884
52		country	stc		Fiber		204975
53	Al Jowf Province	administrative_area_level_1	Zain		All Fixed		439
54	Al Jowf Province	administrative_area_level_1	stc		All Fixed		1439
55	Al Jowf Province	administrative_area_level_1	stc		Fiber		778
56	Al Jowf Province	administrative_area_level_1	Mobily		All Fixed		173
57	Al Qassim Province	administrative_area_level_1	stc		Fiber		7763
58	Al Qassim Province	administrative_area_level_1	Mobily		All Fixed		577
59	Tabuk Province	administrative_area_level_1	stc		All Fixed		4136
60	Aseer Province	administrative_area_level_1	Zain		All Fixed		1873
61	Aseer Province	administrative_area_level_1	stc		All Fixed		10533
62		country	Zain		All Fixed		71872
63	Northern Borders Province	administrative_area_level_1	stc		All Fixed		1247
64	Northern Borders Province	administrative_area_level_1	stc		Fiber		831
65	Northern Borders Province	administrative_area_level_1	Mobily		All Fixed		109
66	Eastern Province	administrative_area_level_1	stc		All Fixed		51776
67	Eastern Province	administrative_area_level_1	stc		Fiber		38026
68	Eastern Province	administrative_area_level_1	Mobily		All Fixed		11061
69	Tabuk Province	administrative_area_level_1	stc		Fiber		2565
70	Tabuk Province	administrative_area_level_1	Mobily		All Fixed		727
71	Aseer Province	administrative_area_level_1	stc		Fiber		3761
72	Aseer Province	administrative_area_level_1	Mobily		All Fixed		740
73	Northern Borders Province	administrative_area_level_1	Salam		All Fixed		96
74	Northern Borders Province	administrative_area_level_1	Salam		Fiber		83
75	Northern Borders Province	administrative_area_level_1	Zain		All Fixed		386
76	Makkah Province	administrative_area_level_1	stc		All Fixed		85591
77	Makkah Province	administrative_area_level_1	stc		Fiber		53432
78	Makkah Province	administrative_area_level_1	Mobily		All Fixed		25657
79	Al Qassim Province	administrative_area_level_1	Salam		All Fixed		780
80	Al Qassim Province	administrative_area_level_1	Zain		All Fixed		380
81	Al Madinah Province	administrative_area_level_1	GO Telecom		All Fixed		315
82	Najran Province	administrative_area_level_1	Zain		All Fixed		196
83	Najran Province	administrative_area_level_1	stc		All Fixed		3032
84	Najran Province	administrative_area_level_1	stc		Fiber		859
85	Al Bahah Province	administrative_area_level_1	Zain		All Fixed		216
86	Al Bahah Province	administrative_area_level_1	stc		All Fixed		1519
87	Al Bahah Province	administrative_area_level_1	stc		Fiber		600
88	Makkah Province	administrative_area_level_1	Zain		All Fixed		22730
89	Hail Province	administrative_area_level_1	stc		All Fixed		2239
90	Hail Province	administrative_area_level_1	stc		Fiber		1368
91	Al Madinah Province	administrative_area_level_1	Salam		All Fixed		1674
92	Al Madinah Province	administrative_area_level_1	Zain		All Fixed		4223
93		country	Mobily		All Fixed		55819
94	Jazan Province	administrative_area_level_1	Zain		All Fixed		1161
95	Jazan Province	administrative_area_level_1	stc		All Fixed		9178
96	Jazan Province	administrative_area_level_1	stc		Fiber		3723
97	Jazan Province	administrative_area_level_1	Mobily		All Fixed		448
98	Riyadh Province	administrative_area_level_1	Salam		Fiber		1745
99	Riyadh Province	administrative_area_level_1	stc		All Fixed		96622
100	Riyadh Province	administrative_area_level_1	stc		Fiber		77644
101	Riyadh Province	administrative_area_level_1	Mobily		All Fixed		15356
102	Al Madinah Province	administrative_area_level_1	stc		All Fixed		19449
103	Al Madinah Province	administrative_area_level_1	stc		Fiber		15834
104	Al Madinah Province	administrative_area_level_1	Mobily		All Fixed		1067
105	Riyadh Province	administrative_area_level_1	Salam		All Fixed		17371
106	Riyadh Province	administrative_area_level_1	Zain		All Fixed		26905
107	Makkah Province	administrative_area_level_1	GO Telecom		Fiber		2
108	Riyadh Province	administrative_area_level_1	GO Telecom		Fiber		38	Do not include
109	Al Madinah Province	administrative_area_level_1	GO Telecom		Fiber		3
110	Makkah Province	administrative_area_level_1	GO Telecom		All Fixed		1242	Do not include
111	Aseer Province	administrative_area_level_1	Salam		All Fixed		209	Do not include
112	Aseer Province	administrative_area_level_1	GO Telecom		All Fixed		257	Do not include
113	Northern Borders Province	administrative_area_level_1	GO Telecom		All Fixed		9	Do not include
Sheet1

Cell Formulas
Range	Formula
J2:J113	J2	=IF(I2=AGGREGATE(14,6,I$2:I$113/((C$2:C$113=C2)*(D$2:D$113=D2)*(E$2:E$113=E2)*(G$2:G$113=G2)),1),"","Do not include")

 

[Armstrong_N14]

oops my bad.. Thank you as always, Sir @Peter_SSs. please delete my post as I can no longer edit it.

 

[Peter_SSs]

please delete my post as I can no longer edit it.

No need to delete it as it may be possible that the OP has updated their version but not their profile, or in any case other/future readers with MAXIFS may find it useful.

 

[vmjan02]

thank you very very much both of you, then function is working all perfect...
peter_ss, yes you are right we have updated all our version now. so maxifs is also working. thank you for your guidence.

armstrongn14, your are perfecrt as well, thank you for the suppor and help and also helping me to understnad as how the maxifs works.

my only one concern, by any changes, as number of rows or record my change so can we have a fix for it.


will this work and there will npot be any problem in futrue.

=IF(I2=AGGREGATE(14,6,I$2:I8000/((C$2:C8000=C2)*(D$2:D8000=D2)*(E$2:E8000=E2)*(G$2:G8000=G2)),1),"","Do not include")

 

[Peter_SSs]

we have updated all our version now. so maxifs is also working.

So, should you be updating your account details?

will this work and there will npot be any problem in futrue.

Try it?