View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Veretax Veretax is offline
external usenet poster
 
Posts: 5
Default How to find the most recent date in a column based on other co



"ufo_pilot" wrote:

Have you tried applying an autofilter?
This should work
You may need more than one column filtered if you have the dates spread out
to more than one column.
you may have to first filter column "C" for the year
then pick up column "B" for the month etc



For Simplicity's sake, Column A is the date actually stored as 10/06/2006
the long date format is how its displayed.

Column B is the Posters Name

Column C is the Contract/Objective

Column D is the Words