Ranking formula based on variable

[scott_od]

I have a table with country performance data & I would like to be able to see the best performing country on a certain date. The idea is that if I change the date in cell E10 (highlighted in red), the formula in E11 would display the country name of the highest value on that date.

In the event that there are 2 countries who both have the highest value, I would like both countries displayed if possible

New Sales	18-Sep	19-Sep	20-Sep	21-Sep	22-Sep	25-Sep
Australia	1	1	2	5	5	3
China	15	25	0	7	0	0
India	25	25	21	24	28	29
Korea	1	3	2	6	5	5
Philippines	1	1	2	2	2	2
Singapore	2	2	2	1	0	0
			Date:	18-Sep
		Best Performer:

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

Is anybody able to help with this, as so far I have not had much luck.

Thank you.

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	F​	G​
1​	New Sales	18-Sep​	19-Sep​	20-Sep​	21-Sep​	22-Sep​	25-Sep​
2​	Australia	1​	1​	2​	5​	5​	3​
3​	China	15​	25​	0​	7​	0​	0​
4​	India	25​	25​	21​	24​	28​	29​
5​	Korea	1​	3​	2​	6​	5​	5​
6​	Philippines	25​	1​	2​	2​	2​	2​
7​	Singapore	2​	2​	2​	1​	0​	0​
8​
9​				Date:	18-Sep​
10​			Best Performer(s)		India
11​					Philippines
12​

In E10 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$7,SMALL(IF(INDEX($B$2:$G$7,0,MATCH(E$9,$B$1:$G$1,0))=MAX(INDEX($B$2:$G$7,0,MATCH(E$9,$B$1:$G$1,0))),ROW($A$2:$A$7)-ROW($A$2)+1),ROWS($E$10:E10))),"")

 

[scott_od]

Aladin you are a genie(us) - thanks so much for your help ray:

 

[Aladin Akyurek]

Aladin you are a genie(us) - thanks so much for your help ray:

Glad to help.