Hello,
I have the table below that I want to display on a list box, I only want to show the items with recent dates without duplicates for example for the training number 001 i only want to show its recent date 03/03/2020, for the training number 002 i want to display its recent date 02/02/2016 and so on...
can anyone show me how to process thank u
I have the table below that I want to display on a list box, I only want to show the items with recent dates without duplicates for example for the training number 001 i only want to show its recent date 03/03/2020, for the training number 002 i want to display its recent date 02/02/2016 and so on...
can anyone show me how to process thank u
Training | Date |
001 | 10/02/2015 |
002 | 02/02/2016 |
003 | 08/08/2018 |
001 | 13/08/2013 |
005 | 17/02/2019 |
004 | 01/07/2014 |
002 | 25/09/2012 |
001 | 03/03/2020 |
005 | 14/04/2017 |