Hi,
I have a table as follows:
I am trying to return the latest date for a given Fruit and Type - can anyone help.
i.e. Pear with a Type of AI_646 should return a date of 10/10/2020.
Can anyone help.
I have to use my work version of Excel which is Office 2010, so I can't use the latest features.
Any guidance would be amazing, I'm going round in circles and never coming out with the correct answer!
I have a table as follows:
I am trying to return the latest date for a given Fruit and Type - can anyone help.
i.e. Pear with a Type of AI_646 should return a date of 10/10/2020.
Can anyone help.
I have to use my work version of Excel which is Office 2010, so I can't use the latest features.
Any guidance would be amazing, I'm going round in circles and never coming out with the correct answer!
Fruit | Type | Date |
Apple | AI_840 | 10/03/2020 |
Pear | AI_646 | 01/03/2020 |
Pear | AI_840 | 12/12/2020 |
Apple | AI_121 | 05/05/2020 |
Orange | AI_123 | 06/06/2020 |
Pear | AI_646 | 10/10/2020 |
Pear | AI_646 | 07/09/2020 |