ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Advanced filter data match (https://www.excelbanter.com/excel-discussion-misc-queries/251192-advanced-filter-data-match.html)

Kirk P.

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

Herbert Seidenberg

Advanced filter data match
 
Excel 2007 Advanced Filter
Manual or macro.
http://www.mediafire.com/file/imzwcz...12_16_09a.xlsm


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com