P
PAL
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.
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.