Hello. Attached spreadsheet, I want to use advanced filter to isolate just product ABC, >6000 revenue. How do I do this my peoplees?
Hello. Attached spreadsheet, I want to use advanced filter to isolate just product ABC, >6000 revenue. How do I do this my peoplees?
You would not use Advanced filters for this, just regular filters....
Filter column B on ABC
Filter column I on >6000
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yeah, that's what I though, but Mr. Bill Jelen aka MR mugfug Excel himself, has this example in his book on how to use advanced filters. It's not working the way that he showed. IMO he gives examples for a lot of advanced filter functions that you can just do in excel.
I always take the apporach to use the tools you know - that work. Learn new tools when you can, and perfect them.
Bottom line, use what works, unless it is really inefficient
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks