Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
Advanced filter a dynamic date range | Excel Worksheet Functions | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Advanced Filter for exact value | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |