Advanced filter data match

K

Kirk P.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top