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

 

[Armstrong_N14]

Mr. Peter's will do the trick. Mine is just a temporary fix. The codes are only good for 4 year length. You need to drag to formula further to the right 12 columns more to increase for 1 year and so on... Glad to help.

 

[vmjan02]

So, should you be updating your account details?

View attachment 99903


Try it?

yes, updated account details, and yes no problem with formula

 

[Peter_SSs]

updated account details

Thanks or doing that.
In that case another option with MAXIFS without a helper column would be

=IF(I2=MAXIFS(I$2:I$113,C$2:C$113,C2,D$2:D$113,D2,E$2:E$113,E2,G$2:G$113,G2),"","Do not include")

 

[Armstrong_N14]

Mr. Peter's will do the trick. Mine is just a temporary fix. The codes are only good for 4 year length. You need to drag to formula further to the right 12 columns more to increase for 1 year and so on... Glad to help.

@vmjan02 disregard this. it was supposed to be for another post. sorry. - I was on my phone and must have mixed things up.

so long as you drag the helper column, you should be good

 

[vmjan02]

Thanks or doing that.
In that case another option with MAXIFS without a helper column would be

=IF(I2=MAXIFS(I$2:I$113,C$2:C$113,C2,D$2:D$113,D2,E$2:E$113,E2,G$2:G$113,G2),"","Do not include")

by a chance can there be a macor, to avoid excel version problem,