Phone | Country | Approval Date |
Iphone | Singapore | 9/1/2016 |
Iphone | Singapore | 9/1/2017 |
Iphone | Vietnam | 9/15/2017 |
Iphone | China | 12/1/2016 |
Samsung | Singapore | 12/1/2017 |
Samsung | China | 12/15/2017 |
Samsung | Turkey | 1/5/2016 |
Samsung | Turkey | 1/5/2017 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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.
Phone | Country | Approval Date |
Iphone | Singapore | 9/1/2017 |
Iphone | Vietnam | 9/15/2017 |
Iphone | China | 12/1/2016 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Can someone please help.
Thanks