Forum Discussion
Filter with IFERROR
I used the FILTER formula to filter few row that contain txt. However, when I use IFERROR to avoid getting error, cells that have more than 256. How can I avoid this error?
I have a look at the screenshot. My problem is that when a cell has more than 255 characters then excel returns error.
I have used LEN function to calculate total characters
In addition. I guess from practical point of view IFERROR() is needed to replace #CALC error if filter is not match by some text. If so, the workaround could be
=IF(COUNTIFS(A:A,"Office"), FILTER(B:B,A:A="Office"), "NA")