Avatar of RTsal

asked on 

filter columns in excel

I have 2 columns in an excel sheet that I want to filter. The cells in each column contains either "YES" or "NO".
I only want to show the rows which have a "YES" in one or both columns. (In other words, hide rows that have "NO" in both columns). I am not sure how to do this by filtering/sorting.
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon