Forum Discussion
Filter with IFERROR
Could you please attached the sample data & share the screenshot of the error you are getting
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more
Cannot attach an excel sheet.
Filter returns
=Filter(A:B,A:A="Office")
| A | B |
| Office | less than 255 character |
| Office | less than 255 character |
| Office | less than 480 character |
| Office | less than 255 character |
Now if I club this formula with IFERROR, it only returns
Formula - Iferror(Filter(A:B,A:A="Office"),"NA")
| A | B |
| Office | less than 255 character |
| Office | less than 255 character |
| Office | NA |
| Office | less than 255 character |
The formula is working fine, I have attached the sample file for your reference.
=IFERROR(FILTER($B$10:$C$13,$B$10:$B$13="Office"),"NA")If you are unable to resolve the issue request you to please re-create the file removing the confidential information and upload the same
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more
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")
