Forum Discussion

humphreyallen's avatar
humphreyallen
Copper Contributor
Sep 08, 2023

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!!

 

  • mtarler's avatar
    mtarler
    Silver Contributor
    make another column with a formula like
    =countif(F2:M2,"Yes")
    then sort by that column

Resources