Sorting items according to their recent dates

[Zsals]

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

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

 

[JoeMo]

Using US region dates - this is an array formula, confirm with ctrl+shift+enter:

Book2
	A	B	C	D	E
1	Training	Date		Training	Latest Date
2	001	2/10/2015		001	3/3/2020
3	002	2/2/2016		002	2/2/2016
4	003	8/8/2018		003	8/8/2018
5	001	8/13/2013		004	7/1/2014
6	005	2/17/2019		005	2/17/2019
7	004	7/1/2014
8	002	9/25/2012
9	001	3/3/2020
10	005	4/14/2017
Sheet2

Cell Formulas
Range	Formula
E2:E6	E2	=MAX(IF($A$2:$A$104=D2,$B$2:$B$10))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Zsals]

Using US region dates - this is an array formula, confirm with ctrl+shift+enter:

Book2
	A	B	C	D	E
1	Training	Date		Training	Latest Date
2	001	2/10/2015		001	3/3/2020
3	002	2/2/2016		002	2/2/2016
4	003	8/8/2018		003	8/8/2018
5	001	8/13/2013		004	7/1/2014
6	005	2/17/2019		005	2/17/2019
7	004	7/1/2014
8	002	9/25/2012
9	001	3/3/2020
10	005	4/14/2017
Sheet2

Cell Formulas
Range	Formula
E2:E6	E2	=MAX(IF($A$2:$A$104=D2,$B$2:$B$10))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thank for your help, I tried to enter the formula but I got an error (synthax error) Iam using French region dates could it be the problem ?

 

[JoeMo]

Thank for your help, I tried to enter the formula but I got an error (synthax error) Iam using French region dates could it be the problem ?

Did you confirm the entry with ctrl+shift+enter, not just enter?