Hello,
I am trying to use the advanced criter filter to filter OUT a value. For example. In the table below, how do I display everything but beverages. I am using the <> to filter this out but it is not working.
Any assistance would be grateful.
Thanks,
nmss18
<tbody>
</tbody><colgroup><col span="3"></colgroup>
I am trying to use the advanced criter filter to filter OUT a value. For example. In the table below, how do I display everything but beverages. I am using the <> to filter this out but it is not working.
Any assistance would be grateful.
Thanks,
nmss18
<form id="aspnetForm" method="post" name="aspnetForm" action="http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-HP010073942.aspx">Type</form> | Salesperson | Sales |
<>Beverages | ||
<form id="aspnetForm" method="post" name="aspnetForm" action="http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-HP010073942.aspx">Type</form> | Salesperson | Sales |
Beverages | Suyama | $5,122 |
Meat | Davolio | $450 |
produce | Buchanan | $6,328 |
Produce | Davolio | $6,544 |
<tbody>
</tbody><colgroup><col span="3"></colgroup>