View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Min Year in an Array

I am looking at an array and trying to return the earliest year. I have
tried this:

{=IF(Export!$A$2:$A$282=A3,YEAR(MIN(Export!$L$2:$L $282,"")))}

Column A is checking the array for a specific name. If it finds it, I would
like the output to be the YEAR of the earliest date in L.

As output, I get either "#VALUE!" or "FALSE".

Thanks.