Excel sorting

Copper Contributor



I am trying to sort the contents of a table in terms of the maximum number of "Yes" values that each row has in columns F to M of the table.


For example if row 36 has "Yes" in B, C, D, E and F (let us simplify and say this is the maximum number of "Yes" values), then row 36 should be at the top. If row 2 has "Yes" values in only B, D and E, then it should come after row 36: row 36 has 5 "Yes" values, row 2 has 3. 


How do I do this? I am using excel on a mac, if that makes a difference. Thanks very much!!


1 Reply
make another column with a formula like
then sort by that column