Summarize Yes and No

[jingmu]

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.

[NicoleJohnson · Accepted solution]

You are correct, the Max of Yes/No will give you Yes, so you shouldn't need to convert them to numbers before the summarize tool! Just select Max for your Yes/No field and the results should give you Yes if there is at least one Yes in that column.

Cheers,
NJ

[jingmu]

I just tried and it worked fine. I am glad to know the trick. Thank you very much Nicole!