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
You are right, VishalRathore .
Actually, Filter - Iferror Functions Combination doesn't return cell text value if the number of characteristics is more than 256.
Should find solution:)