How do I extract a row of data from a cell array?

I have a 3 x 4 cell array, (a), that looks like this;

'Due'  55000  1  100
'WFR'  55100  2  200
'Due'  55200  20  300

where column 1 is of char, and the others are doubles.

I'm attempting to extract the rows of data based on the values in the 3rd column being greater than 2 (20 in this case).

Desired output is cell b = 'Due' 55200 20 300

I'm using the following code;

b=a(~ismember(a(:, 3), [1 2]), :);

I keep getting the following error message;

"Input A of class cell and input B of class double must be cell arrays of strings, unless one is a string"

This is the first time I've attempted to extract rows of data from cell arrays. Am I doing something wrong? If so, how do I approach this problem in order to get b?

Answer 1

[Andrei Bobrov]

b = a(cat(1,a{:,3}) > 2,:)

[Brad]

Andrei, super catch. Thanks.

[fei peng]

GOOD

[Bryan]

Excellent! Thanks

Answer 2

[Sara]

If you know which row you want to extract, you can do:

b = a(row,:);

[Brad]

Sara, I'm looking to extract the row based on a specific value in the 3rd column (which varies). I did try your approach and it works. But I need some ideas on how to approach this when the values in the 3rd column are not equal to 1 or 2. Thanks.