Hi all I have got a table where I want to assign number bigger than the highest number already there in the table to the ones assigned zero. How can I do that.

5 Comments

You say you have a highest number , do you mean a threshold value?
If I am having one of the column with 1 2 3 0 4 5 0 and I want it has 1 2 3 6 4 5 7.
Thank you
a=[1 2 3 0 4 5 0];
a(~a) = max(a)+(1:nnz(~a))
@madhan,can you write that as an answer? I don't think it can be done any simpler.
@Guillaume: Done :)

Sign in to comment.

 Accepted Answer

a = [1 2 3 0 4 5 0];
a(~a) = max(a) + (1:nnz(~a))

More Answers (1)

Something like this?
table = randi([0 10],10,10);
tableMax = max(max(table));
table(table==0) = tableMax+1;
% Or Just
table(table==0) = Inf;

1 Comment

If I am having one of the column with 1 2 3 0 4 5 0 and I want it has 1 2 3 6 4 5 7. How can I do that
Thank you

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!