ExcelBanter - Can't filter/clean cells that contain #NAME?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can't filter/clean cells that contain #NAME? (https://www.excelbanter.com/excel-programming/444344-re-cant-filter-clean-cells-contain-name.html)

Parag

Can't filter/clean cells that contain #NAME?

Solved it. Just used the ISERROR function and for some reason, it DOES filter with that.

All times are GMT +1. The time now is 03:19 PM.