stillanewbie
New Member
- Joined
- Nov 8, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I need to return the most recent date that is associated to a columns inputs. So in the example: for every Flavor input (of which there can be multiple of the same) there is a corresponding date. I would like to return the most recent date associated with each flavor.
Sorry if I haven't explained this too well but I think the below table will give you a good idea of what I am trying to achieve. Thanks!
Sorry if I haven't explained this too well but I think the below table will give you a good idea of what I am trying to achieve. Thanks!
DATE | Flavor | Expected Output |
Dec-12 | Choc | Dec-18 |
Dec-14 | Vanilla | Dec-20 |
Dec-18 | Choc | Dec-18 |
Dec-17 | Strawberry | Dec-17 |
Dec-20 | Vanilla | Dec-20 |
Dec-09 | Strawberry | Dec-17 |