Get index of rows containing text in a column

Hi,

Please see the attached table.

How can I determine the ROW NUMBERS for all rows containing a "X" in the column C.

I tried using the following...

exampleTable(:,3)=='X'

However, I received the following error: Undefined function 'eq' for input arguments of type 'cell'.

Answer 1

[Azzi Abdelmalek]

[a,b,v]=xlsread('exampleTable_Matlab.xlsx')
c3=v(:,3)
idx=strcmp(c3,'x')

To ignore case, use strcmpi

[John]

Thanks a lot!