Good afternoon!
I'm trying to create an array formula that will return a text string from a list of text/Month items.
Here is what I have so far:
=IF(MONTH(Completed!D2:D4)=12,IF(MIN(Completed!B2:B4),Completed!A2:A4,"NONE"))
The idea is that Column D contains a list of file completion dates, Column B contains the original file dates and Column A contains the text value to return.
The formula should return the text from the row with the oldest original file date that was completed in December (or return "NONE" if nothing is found).
Neat idea, but it doesn't work. What am I doing wrong here?
I'm trying to create an array formula that will return a text string from a list of text/Month items.
Here is what I have so far:
=IF(MONTH(Completed!D2:D4)=12,IF(MIN(Completed!B2:B4),Completed!A2:A4,"NONE"))
The idea is that Column D contains a list of file completion dates, Column B contains the original file dates and Column A contains the text value to return.
The formula should return the text from the row with the oldest original file date that was completed in December (or return "NONE" if nothing is found).
Neat idea, but it doesn't work. What am I doing wrong here?