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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,324
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,324
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,113,824
Messages
5,544,541
Members
410,619
Latest member
gregor222
Top