How to use find function to find input of 'cell' type?

Hello, I have 'raw' as an array of all cells read from excel (number or non-number). I would like to find the row numbers where the cell is 'ABC', and return the first row.

When I use 'find' function it returns an error:

>>find(raw, 'ABC','first')
Undefined function 'find' for input arguments of type 'cell'.

Is there a way to find the row for a cell content in Matlab? If so, how can I find the row of both that one vector having some cell, and another vector having another cell?

[Image Analyst]

Do you know what column ABC will be in? Or do we have to find that too? ANd what does "find the row of both that one vector having some cell, and another vector having another cell" mean? For example, what if 'ABC' shows up in row 2, column 3, and also in row 15, column 8? What do you want to return - which of those 4 numbers?

[C Zeng]

'ABC' is the entry, I want to find which row of columns that have that cell as an entry?

For the second question, I want to find out the row that both 'ABC' in the column and maybe another cell '123' in another column. Is it clear?

[Image Analyst]

No it's not. But see if my answer below is okay.

[C Zeng]

Thanks!

Answer 1

[Image Analyst]

ca = {'abc', 'def'; 
  'abcx', 'row 2'; 
  'yy', 'row 2 abc'; 
  'zzzz', 'abc'; 
  'abc', 'line 3'}
[ia, ib] = ismember(ca, 'abc')
firstRow = find(ia(:, 1), 1, 'first')

In the command window:

ca = 
    'abc'     'def'      
    'abcx'    'row 2'    
    'yy'      'row 2 abc'
    'zzzz'    'abc'      
    'abc'     'line 3'   
ia =
     1     0
     0     0
     0     0
     0     1
     1     0
ib =
     1     0
     0     0
     0     0
     0     1
     1     0
firstRow =
     1

[C Zeng]

What if I want to find out which row return number j (j changes in the loop), where the column vector is of cells.

if I input: ismember(list, 'j'); it returns an error: Input A of class cell and input B of class cell must be cell arrays of strings, unless one is a string.

Thanks!

[Image Analyst]

Please create a cell array like I did so I can work on it. And tell me which row and column you want to find/detect and return to your program.