find the row and column value of a specific value in cell array

i have a cell array with values

cellarr = {'a','b','c',3,5;'b',5,'a',[],[];'a','c',3,'a',4;'b','a','c','c',3};

i wanted to find the location where a particular number or string occurs

for example i want to get the location where the number = 3

so my expected output is

1st row 3rd column
3rd row 3rd column
4th row 5th column

[row,col] = find(___)

i want both the row and column position as it comes for find function

find not working with cell array

[Xingwang Yong]

https://www.mathworks.com/matlabcentral/answers/84242-find-in-a-cell-array

[Elysi Cochin]

i tired that but not getting the row and column value

[Xingwang Yong]

After using find(), you just need to convert the linear index into row and col index, see ind2sub

Answer 1

[Rik]

You need to use a bit of trickery to use find (ismember will not work normally either).

cellarr = {...
    'a','b','c', 3 ,5;...
    'b', 5 ,'a',[] ,[];...
    'a','c', 3 ,'a',4;...
    'b','a','c','c',3};
val=3;
[row,col] = find(cellfun(@(x) isequal(val,x),cellarr));
[row,col]

ans = 3×2

3 3 1 4 4 5

[Elysi Cochin]

is it possible to get in order?

row col
1    4
3    3
4    5

or sort based on row

[Rik]

This is the default order for find, but you can use sort (and its second output) to sort on row instead of column.