Sorting items according to their recent dates

Zsals

New Member
Joined
Jun 1, 2020
Messages
4
Office Version
  1. 2007
Platform
  1. Windows
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



TrainingDate
00110/02/2015
00202/02/2016
00308/08/2018
00113/08/2013
00517/02/2019
00401/07/2014
00225/09/2012
00103/03/2020
00514/04/2017
 

Some videos you may like

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
Joined
May 26, 2009
Messages
17,326
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
Joined
Jun 1, 2020
Messages
4
Office Version
  1. 2007
Platform
  1. Windows
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
Joined
May 26, 2009
Messages
17,326
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,661
Messages
5,549,280
Members
410,907
Latest member
Gan_77
Top