View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Filtering by newest date

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