Max value with range

vmjan02

Well-known Member
Joined
Aug 15, 2012
Messages
1,134
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
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.

1696616935325.png


1696617039029.png


also sharing the samble data as well.

Test.xlsx
ABCDEFGHIJ
1aggregate_dateplace_nameregionplace_typeisp_nameaggregation_periodplatformtest_countsample_countResult
21-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1GO TelecomMonthAll Fixed5123
31-Aug-23Saudi ArabiacountryGO TelecomMonthFiber7468
41-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1SalamMonthFiber2719
51-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1GO TelecomMonthFiber44
61-Aug-23Saudi ArabiacountrystcMonthAll Fixed107Do not include
71-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1GO TelecomMonthFiber22
81-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1stcMonthAll Fixed107Do not include
91-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1stcMonthAll Fixed22Do not include
101-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1SalamMonthFiber5313
111-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1GO TelecomMonthFiber21
121-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1GO TelecomMonthFiber4742
131-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1SalamMonthFiber21
141-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1GO TelecomMonthFiber1515
151-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1GO TelecomMonthAll Fixed8214
161-Aug-23Saudi ArabiacountrystcMonthAll Fixed22Do not include
171-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1GO TelecomMonthFiber33
181-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1MobilyMonthAll Fixed7230
191-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1SalamMonthAll Fixed86
201-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1GO TelecomMonthAll Fixed2310
211-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1SalamMonthAll Fixed4122
221-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1GO TelecomMonthAll Fixed2406776
231-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1SalamMonthAll Fixed347129
241-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1GO TelecomMonthAll Fixed261132
251-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1GO TelecomMonthAll Fixed25391
261-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1SalamMonthAll Fixed582216
271-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1GO TelecomMonthAll Fixed946270
281-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1GO TelecomMonthAll Fixed13124
291-Aug-23Saudi ArabiacountryGO TelecomMonthAll Fixed195345800
301-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1GO TelecomMonthAll Fixed1810
311-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1GO TelecomMonthAll Fixed37721284include
321-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1SalamMonthFiber583152
331-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1GO TelecomMonthAll Fixed85712950
341-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1SalamMonthAll Fixed96973384
351-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1MobilyMonthAll Fixed15351
361-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1SalamMonthAll Fixed260307841
371-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1SalamMonthFiber218776574
381-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1ZainMonthAll Fixed6798913305
391-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1SalamMonthAll Fixed1063319
401-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1SalamMonthFiber13246
411-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1ZainMonthAll Fixed3514847
421-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1SalamMonthAll Fixed23588
431-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1MobilyMonthAll Fixed21054
441-Aug-23Saudi ArabiacountrySalamMonthAll Fixed9877031859
451-Aug-23Saudi ArabiacountrySalamMonthFiber280198669
461-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1GO TelecomMonthAll Fixed1357167
471-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1ZainMonthAll Fixed45701109
481-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1stcMonthAll Fixed3159510107
491-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1SalamMonthFiber14651
501-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1SalamMonthAll Fixed32183
511-Aug-23Saudi ArabiacountrystcMonthAll Fixed1033229288884include
521-Aug-23Saudi ArabiacountrystcMonthFiber664190204975include
531-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1ZainMonthAll Fixed2056439
541-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1stcMonthAll Fixed50041439
551-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1stcMonthFiber3010778
561-Aug-23Al Jowf ProvinceAl Jowf Provinceadministrative_area_level_1MobilyMonthAll Fixed480173
571-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1stcMonthFiber249207763
581-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1MobilyMonthAll Fixed1629577
591-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1stcMonthAll Fixed148184136
601-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1ZainMonthAll Fixed82131873
611-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1stcMonthAll Fixed2884110533
621-Aug-23Saudi ArabiacountryZainMonthAll Fixed31328471872
631-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1stcMonthAll Fixed40921247
641-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1stcMonthFiber2903831
651-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1MobilyMonthAll Fixed332109
661-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1stcMonthAll Fixed17282151776
671-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1stcMonthFiber12639238026
681-Aug-23Eastern ProvinceEastern Provinceadministrative_area_level_1MobilyMonthAll Fixed3830811061
691-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1stcMonthFiber86532565
701-Aug-23Tabuk ProvinceTabuk Provinceadministrative_area_level_1MobilyMonthAll Fixed2504727
711-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1stcMonthFiber105223761
721-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1MobilyMonthAll Fixed2219740
731-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1SalamMonthAll Fixed41396
741-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1SalamMonthFiber32183
751-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1ZainMonthAll Fixed1761386
761-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1stcMonthAll Fixed28659885591
771-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1stcMonthFiber16899853432
781-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1MobilyMonthAll Fixed8777025657
791-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1SalamMonthAll Fixed2487780
801-Aug-23Al Qassim ProvinceAl Qassim Provinceadministrative_area_level_1ZainMonthAll Fixed1005380
811-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1GO TelecomMonthAll Fixed1276315
821-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1ZainMonthAll Fixed890196
831-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1stcMonthAll Fixed76583032
841-Aug-23Najran ProvinceNajran Provinceadministrative_area_level_1stcMonthFiber2647859
851-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1ZainMonthAll Fixed851216
861-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1stcMonthAll Fixed48201519
871-Aug-23Al Bahah ProvinceAl Bahah Provinceadministrative_area_level_1stcMonthFiber1826600
881-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1ZainMonthAll Fixed10276122730
891-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1stcMonthAll Fixed79312239
901-Aug-23Hail ProvinceHail Provinceadministrative_area_level_1stcMonthFiber52331368
911-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1SalamMonthAll Fixed52251674
921-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1ZainMonthAll Fixed149054223
931-Aug-23Saudi ArabiacountryMobilyMonthAll Fixed18747255819
941-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1ZainMonthAll Fixed54081161
951-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1stcMonthAll Fixed400999178
961-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1stcMonthFiber156773723
971-Aug-23Jazan ProvinceJazan Provinceadministrative_area_level_1MobilyMonthAll Fixed1682448
981-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1SalamMonthFiber48781745
991-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1stcMonthAll Fixed36057596622
1001-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1stcMonthFiber24739077644
1011-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1MobilyMonthAll Fixed4919515356
1021-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1stcMonthAll Fixed6047819449
1031-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1stcMonthFiber4594515834
1041-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1MobilyMonthAll Fixed26441067
1051-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1SalamMonthAll Fixed5182217371
1061-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1ZainMonthAll Fixed9921926905
1071-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1GO TelecomMonthFiber22
1081-Aug-23Riyadh ProvinceRiyadh Provinceadministrative_area_level_1GO TelecomMonthFiber4338
1091-Aug-23Al Madinah ProvinceAl Madinah Provinceadministrative_area_level_1GO TelecomMonthFiber33
1101-Aug-23Makkah ProvinceMakkah Provinceadministrative_area_level_1GO TelecomMonthAll Fixed36371242Do not include
1111-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1SalamMonthAll Fixed555209Do not include
1121-Aug-23Aseer ProvinceAseer Provinceadministrative_area_level_1GO TelecomMonthAll Fixed906257Do not include
1131-Aug-23Northern Borders ProvinceNorthern Borders Provinceadministrative_area_level_1GO TelecomMonthAll Fixed179Do not include
Sheet1
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
with respect to placename, region, place type, isp name and platform
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top