How to get row index satisfy the condition in cell array

Hi,

I have celle array, and want to find row index where the cell value is equal to 1.

data:

'Group1' 'PVT' 'Power' '01-06-2019' [0]

'Group1' 'PVT' 'Power' '01-06-2019' [1]

'Group1' 'PVR' 'VFT' '01-06-2019' [1]

'Group1' 'PMR' 'VGA' '01-06-2019' [1]

I want to get row where the value is equal to 1 in last column. I tried below code but does not work.

Method1:

IndexC = strfind(cell2mat(data{:,end}),'1');

method2:

idx2=strfind(data(:,end),'1');

Both does not worlk.

Answer 1

[madhan ravi]

The last column doesn't seem to be a char:

data(cell2mat(data(:,end))==1,:)

[madhan ravi]

row_indices = find(cell2mat(data(:,end))==1)