May 25 2022 01:53 PM
I use excel spreadsheets to monitor performance on a quarterly basis. In addition to numeric values, reports include a descriptions/narratives. However, sometimes the narrative information provided exceeds 255 characters. I use If and IFS array formulas to produce a status report, based on the most up to date information. i.e. at the end of the third quarter, if no report was provided for an indicator, data for q2 would be presented, if nothing is there for q2 then the q1 data is presented. However, where the more than 255 characters a #Value error is returned.
This spreadsheet illustrates the issue
Note if the formula is NOT an array it works for each row. However, that is not a practical solution given the fact I am tracking over a thousand of rows and I have found changing all my formulas to array functions 'lightens' the workbook.
Thank you for any insight or workarounds anyone can provide.
May 25 2022 03:02 PM
May 25 2022 03:21 PM