A
Al
Is there a way to filter Excel data to show only the newest dates
Here is an example - I have taken the rest of the data from the example to
make it simple
NAME END_DATE
AB 2009/01/18
AB 2008/05/13
AB 2008/03/09
AG 2009/07/12
AG 2009/03/31
AG 2008/04/06
AL 2008/02/29
AL 2006/03/07
I want to filter the list to show only the newest ones below
NAME END_DATE
AB 2009/01/18
AG 2009/07/12
AL 2008/02/29
can that be done?
Thanks in advance
Al
Here is an example - I have taken the rest of the data from the example to
make it simple
NAME END_DATE
AB 2009/01/18
AB 2008/05/13
AB 2008/03/09
AG 2009/07/12
AG 2009/03/31
AG 2008/04/06
AL 2008/02/29
AL 2006/03/07
I want to filter the list to show only the newest ones below
NAME END_DATE
AB 2009/01/18
AG 2009/07/12
AL 2008/02/29
can that be done?
Thanks in advance
Al