isnan cellfun and dropping rows

Hi, in my cell array X, I would like to drop all rows where the value of the 4th column is NaN (the new cell array is Y).

I am trying this:

Y = X(~any(cellfun(@isnan,X(:,4),'UniformOutput',false),2),:)

It returns the following error: Undefined function 'any' for input arguments of type 'cell'.

How do I have to change the code?

[Stephen23]

Not enough information: what is the cell array? What size are the arrays inside the cell array? Are all cell contents numeric?

Answer 1

[Stephen23]

Making some guesses here, but this might do what you want:

 Y = X(cellfun(@(x)any(isnan(x)),X(:,4)),:)

[phlie]

Thank you for answering my incomplete question anyway. Your code works, but it does the exact opposite of what I wish to do. With a tilde before isnan, it works as I was hoping :)

[Stephen23]

If the content of each cell is a scalar, you could even do this:

 Y = X(~cellfun(@isnan,X(:,4)),:)