I have a dataset in which some of the columns are of yes/no. I wish to use the summarize tool where if there is at least one Yes in the column, return Yes, otherwise return No.
One way I used is to replace Yes/No to 1/0, then select the Maximum value for each column, then switch back to Yes/No. I am just wondering if I can do this with Yes/NO.
Thank you.
Solved! Go to Solution.
I just tried and it worked fine. I am glad to know the trick. Thank you very much Nicole!