Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've got a list of data with headers prod_owner and acct_id. I'm trying to
build an advanced filter that first finds those acct_id's beginning with a. Then of that list find those where acct_id = prod_owner. I've got this in my filter, but it doesn't return any results. If I do ACCT_ID or Column Match by themselves they do return results - what I really need is for them to work together. ACCT_ID Column Match =a* ACCT_ID = PROD_OWNER |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
missing data w/ advanced filter | Excel Worksheet Functions | |||
Advanced Filter/Extracting Data | Excel Discussion (Misc queries) | |||
why can't i use the advanced filter on my data | Excel Discussion (Misc queries) | |||
advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |