How to find row and column of a value in cell array

I have this Cell Array ‘A’ of size 3 by 7

A = {
3  4  []  []  []  []  []
2  6  -2  2  -2.1  2  2
-5  -5  25  1  []  []  []}

I want the result of max value of this cell array i.e. ‘25’ at row 3 and column 3 shall be displayed.

Answer 1

[Walter Roberson]

B = A;
B(cellfun(@isempty, B)) = {NaN};
[maxval, maxidx] = max( reshape(cell2mat(B), [], 1) );
[maxrow, maxcol] = ind2sub(size(B), maxidx);

[maxval, maxrow, maxcol]

Note: this treats empty and NaN the same. If the array happened to consist entirely of NaN and empty locations, the code would return location 1 1, which might in some sense be incorrect because that location might be empty. However in such a case it is difficult to argue that NaN is a valid maximum since by definition NaN is Not A Number.

[Vishal Sharma]

its giving row and column as 1 and 1 which should have been row=3 and column = 3... that was my question....The maximum value and index as per your solution can be determined by this code

[maxval idx] = max([B{:}]);

[Vishal Sharma]

Please tell me how to get the solution of row= 3 and column = 3

[Jorge Mario Guerra González]

That solution worked fine for me...

Rememeber to assing

A={3  4  []  []  []  []  []; 2  6  -2  2  -2.1  2  2; -5  -5  25  1  []  []  []};

[Vishal Sharma]

The index is '8'.... I want to get the solution in terms of rows (3rd) and column (3rd).... That's my main problem....

[Walter Roberson]

maxrow and maxcol give that information.

With your data

   A = {
  3  4  []  []  []  []  []
  2  6  -2  2  -2.1  2  2
  -5  -5  25  1  []  []  []}

then my code

B = A;
B(cellfun(@isempty, B)) = {NaN};
[maxval, maxidx] = max( reshape(cell2mat(B), [], 1) );
[maxrow, maxcol] = ind2sub(size(B), maxidx);

[maxval, maxrow, maxcol]

is going to create an answer

25     3     3

which is the maximum value then the row it is at and the column it is at.