Thread: Filter by Latest Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephane Quenson Stephane Quenson is offline
external usenet poster
  
Posts: 53
Default Filter by Latest Date
An idea to consider: you could add an additional column with the function
RANK([date], [whole range]) and filter with the value 1 in that column.

Stephane.

Reply With QuoteReply With Quote