![]() |
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 |
Advanced filter data match
|
All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com