How do I filter view two columns OR instead of AND?
Click on Column D. On the menu click ‘Data’. Select ‘Create a filter’. Click the filter icon that appeared at the top of Column D. Select ‘Filter by condition’. Click the ‘None’ box and scroll down to ‘Custom formula is’. Select and enter =OR(D:D=”x”,E:E=”x”) in value or formula. Click OK. Alternatively, you can create a new sheet … Read more