View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kirk P. Kirk P. is offline
external usenet poster
 
Posts: 66
Default Advanced filter data match

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