Forum Discussion
humphreyallen
Sep 08, 2023Copper Contributor
Excel sorting
Hello,
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!!
- mtarlerSilver Contributormake another column with a formula like
=countif(F2:M2,"Yes")
then sort by that column