<div>
You want to use autofilter.<br />
<br />
Either select the whole data section, or if it is a table i think you only need to select a cell.<br />
Then turn on autofilter<br />
<br />
You will get a drop-down filter tool in each column heading that you can use to adjust filtering.<br />
<br />
For complete info, you might try<br />
<a href="http://www.contextures.com/xlautofilter01.html" rel="ugc">http://www.contextures.com/xlautofilter01.html</a>
</div>


<div>
I knew how to do it using an additional column but I wanted to see if there was away to filter it without adding another column
</div>


<div>
<div class="content wysiwyg-content">
I have 2 columns in an excel sheet that I want to filter. The cells in each column contains either &quot;YES&quot; or &quot;NO&quot;.<br />
I only want to show the rows which have a &quot;YES&quot; in one or both columns. (In other words, hide rows that have &quot;NO&quot; in both columns). I am not sure how to do this by filtering/sorting.
</div>
</div>


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.

You want to use autofilter.

Either select the whole data section, or if it is a table i think you only need to select a cell.
Then turn on autofilter

You will get a drop-down filter tool in each column heading that you can use to adjust filtering.

For complete info, you might try
http://www.contextures.com/xlautofilter01.html

I knew how to do it using an additional column but I wanted to see if there was away to filter it without adding another column

filter columns in excel

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.