i have an excel file row=10,column=3, I want to show a text message if any of the column is zero

For example if column 1 is 0 then I want to show 'column one is zero'.

Answer 1

[Wayne King]

Will a column either contain all zeros or not? In other words is it possible to have some zeros in a column, but not all zeros?

If a column either contains all zeros or none, you can do

 X = ones(10,5);
 X(:,3) = 0;
 idx = find(~any(X,1)); 
 fprintf('Column %2d is zero.\n',idx)

[asaduzzaman nur]

The column will contain all zeros Actually I want to show this on my GUI axis