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
