Using the Filter Function, I want filter a column on the errors

[laxcoug]

I have a range of data, and some of the columns contain formulas. Some of the formulas error which isn't a problem. I would like to use the filter feature on another sheet and filter the column that has errors, specifically filtering FOR the errors.

So I think It should look like: =filter(Array,column,error criteria)

What I'm trying to figure out is what to put into the error criteria. I have tried iserror and iserr and neither works.

Thanks in advance for any ideas!

 

[RoryA]

The basic gist would be:

=FILTER(array,ISERROR(column))