Thread: first cell in a column with a specific value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default first cell in a column with a specific value
=INDEX(A2:A114,MATCH(2005,YEAR(A2:A114),0))

ctrl+shift+enter (not just enter)


"mpierre" wrote:

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