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

See:

http://www.microsoft.com/office/comm...1-36a567811381
--
Gary''s Student - gsnu200813


"Al" wrote:

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

Thanks but I wanted to be able to filter the whole thing at once and only
have the records with the latest dates showing in the spreadsheet

The example you provided seems to do it one by one unless I am missing
something - if so could you proved an example of the VLOOKUP you would use
for this?

Thanks
Al


"Gary''s Student" wrote:

See:

http://www.microsoft.com/office/comm...1-36a567811381
--
Gary''s Student - gsnu200813


"Al" wrote:

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