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?
8 Replies
Please follow the below link
http://excel.tips.net/T003163_Charac...for_Cells.html
Just mention that you can enter up to 32,767 characters in a cell of later versions of Excel and display 1 024 characters in a cell.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
