Thread: first cell in a column with a specific value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mpierre mpierre is offline
external usenet poster
  
Posts: 7
Default first cell in a column with a specific value
I have a column of dates in the format mm/dd/yyyy. I want to find the first
occurence of the year 2005 in that column.
LOOKUP(2005,YEAR($A$2:$A$114),$A$2:$A$114) gives me the last occurence. How
can I find the first occurence? Any ideas?
Reply With QuoteReply With Quote