Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default Advanced filter data match

Excel 2007 Advanced Filter
Manual or macro.
http://www.mediafire.com/file/imzwcz...12_16_09a.xlsm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing data w/ advanced filter Joe Excel Worksheet Functions 6 September 11th 09 03:21 PM
Advanced Filter/Extracting Data jayrthomas Excel Discussion (Misc queries) 3 May 11th 06 01:42 AM
why can't i use the advanced filter on my data pinta Excel Discussion (Misc queries) 2 September 3rd 05 06:41 PM
advanced filter - can't match a long text cell simpsons_rule Excel Discussion (Misc queries) 7 May 14th 05 11:00 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"