Select the output based on multiple column conditions

[rac241985]

[TABLE="width: 240"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Phone[/TD]
[TD]Country[/TD]
[TD]Approval Date[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]Singapore[/TD]
[TD="align: right"]9/1/2016[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]Singapore[/TD]
[TD="align: right"]9/1/2017[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]Vietnam[/TD]
[TD="align: right"]9/15/2017[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]China[/TD]
[TD="align: right"]12/1/2016[/TD]
[/TR]
[TR]
[TD]Samsung [/TD]
[TD]Singapore[/TD]
[TD="align: right"]12/1/2017[/TD]
[/TR]
[TR]
[TD]Samsung[/TD]
[TD]China[/TD]
[TD="align: right"]12/15/2017[/TD]
[/TR]
[TR]
[TD]Samsung[/TD]
[TD]Turkey[/TD]
[TD="align: right"]1/5/2016[/TD]
[/TR]
[TR]
[TD]Samsung[/TD]
[TD]Turkey[/TD]
[TD="align: right"]1/5/2017[/TD]
[/TR]
</tbody>[/TABLE]

I have 3 columns as shown above. In column B, the country maybe repeated twice. How can I return only a specific row which has the latest approval date for each product in every country. I have a drop down menu formula based on the Index function where if the user selects Iphone I should see the following output.

[TABLE="width: 240"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Phone[/TD]
[TD]Country[/TD]
[TD]Approval Date[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]Singapore[/TD]
[TD="align: right"]9/1/2017[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]Vietnam[/TD]
[TD="align: right"]9/15/2017[/TD]
[/TR]
[TR]
[TD]Iphone[/TD]
[TD]China[/TD]
[TD="align: right"]12/1/2016[/TD]
[/TR]
</tbody>[/TABLE]


Can someone please help.

Thanks

 

[Kenneth Hobson]

Make a helper column. The filter would be True for it and Iphone for field1.