# Sorting items according to their recent dates

#### Zsals

##### New Member
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### JoeMo

##### MrExcel MVP
Using US region dates - this is an array formula, confirm with ctrl+shift+enter:
Book2
ABCDE
1TrainingDateTrainingLatest Date
20012/10/20150013/3/2020
30022/2/20160022/2/2016
40038/8/20180038/8/2018
50018/13/20130047/1/2014
60052/17/20190052/17/2019
70047/1/2014
80029/25/2012
90013/3/2020
100054/14/2017
Sheet2
Cell Formulas
RangeFormula
E2:E6E2=MAX(IF(\$A\$2:\$A\$104=D2,\$B\$2:\$B\$10))
Press CTRL+SHIFT+ENTER to enter array formulas.

#### Zsals

##### New Member
Using US region dates - this is an array formula, confirm with ctrl+shift+enter:
Book2
ABCDE
1TrainingDateTrainingLatest Date
20012/10/20150013/3/2020
30022/2/20160022/2/2016
40038/8/20180038/8/2018
50018/13/20130047/1/2014
60052/17/20190052/17/2019
70047/1/2014
80029/25/2012
90013/3/2020
100054/14/2017
Sheet2
Cell Formulas
RangeFormula
E2:E6E2=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

##### MrExcel MVP
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?

Replies
4
Views
68
Replies
2
Views
17
Replies
4
Views
71
Replies
7
Views
80
Replies
2
Views
138