J
John
I have a spreadsheet that outlines performance to date by month. The months
are listed across a row (D31-031) with text based indicators three rows
beneath (D34-O34). This cells in row 34 are not null as they have a formula.
The formula returns "" if no data has been input for that month (rows 32 and
33).
At the far right of this I have an "Overall Status" cell (P32) that I want
to return the indicator in the most recent month containing data. I see many
array forumla solutions for numeric based questions like mine but nothing for
text. Any help out there?
zdjb
Thanks in advance.
are listed across a row (D31-031) with text based indicators three rows
beneath (D34-O34). This cells in row 34 are not null as they have a formula.
The formula returns "" if no data has been input for that month (rows 32 and
33).
At the far right of this I have an "Overall Status" cell (P32) that I want
to return the indicator in the most recent month containing data. I see many
array forumla solutions for numeric based questions like mine but nothing for
text. Any help out there?
zdjb
Thanks in advance.