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,...
mtarler
Sep 08, 2023Silver Contributor
make another column with a formula like
=countif(F2:M2,"Yes")
then sort by that column
=countif(F2:M2,"Yes")
then sort by that column