ExcelBanter - Advanced Filter Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Advanced Filter Function (https://www.excelbanter.com/excel-worksheet-functions/90585-advanced-filter-function.html)

carl

Advanced Filter Function

I am using the advanced filter function. Here is my criteria list:

Symbol
AMR
BA
BP

Here's is the result:

Symbol
BA
BA
BA
BA
BA
BA
BAC
BAC
BA
BA
BA
BA
BA
BA
AMR
BAC
BAC
AMR
BAC
BAC
BAC
BAC
BAX
BAX
BAC
BAC
BAC
BAC
BA
BAC
BAC
BA

Is there any way to have the filter result contain only the 3 symbols in the
criteria list ?

Thank you in advance.

Miguel Zapico

Advanced Filter Function

If you want only exact results, you may change your criteria to:
="=AMR"
="=BA"
="=BP"

Hope this helps,
Miguel.

"carl" wrote:

I am using the advanced filter function. Here is my criteria list:

Symbol
AMR
BA
BP

Here's is the result:

Symbol
BA
BA
BA
BA
BA
BA
BAC
BAC
BA
BA
BA
BA
BA
BA
AMR
BAC
BAC
AMR
BAC
BAC
BAC
BAC
BAX
BAX
BAC
BAC
BAC
BAC
BA
BAC
BAC
BA

Is there any way to have the filter result contain only the 3 symbols in the
criteria list ?

Thank you in advance.

All times are GMT +1. The time now is 04:15 AM.