• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chandoo - Advanced Filter

Montrey

Montrey

Member
I don't think you have done a post on advanced filter. But it is quite a godly feature and basically acts exactly like SQL.


I learned how to use it a few days ago and then showed it to another department. One monthly process that usually took them 1-2 days now takes them 15 min.


Here is the link that goes over advanced filter and how to use it w/ examples.

http://www.dailydoseofexcel.com/archives/2012/07/07/excel-advanced-filter/


If you have yet to use advanced filter, learn it and be amazed!
 
Adding my two cents, aka two links:

http://www.contextures.com/xladvfilter01.html

http://www.contextures.com/xladvfilter02.html


=)

I will say, Tushar Mehta did an excellent job on the write-up (at dailydoseofexcel), and gives an abundant amount of examples.
 
Thanks for the links. Btw, we do have an article on that. See here please http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters
 
You must log in or register to reply here.
Back
Top