Create Custom Filters Using Excel Advanced Filter 

Very helpful. I was searching for this solution for long.. thanks a lot

Very helpful, thanks

Thank you it was very helpful...!!! I have a question- How to use Advance Filter option if I want to use it for criteria as -''does not contain'' items for a particular column and it will have multiple criteria for "does not contain". eg - my data contains a column with text having - // , \\ , 0 , etc within some text data. - I want to pull only those which does not contain all this forward and backward slash and zeros etc - I tried using Autofilter option in custom filter but it cannot serve more then 2 conditions. -I have to create a Macro for this action to save as a templet for future use of different reports of same type, for text to be cleaned. So here cannot use just filter to select which data I need as that will not solve purpose for macro. Please let me know if this is something workable ..? Thank you..!!

great explanation. What if I want a value greater than something, can that be done in an advanced filter?

Hello, thanks for your clip. I have a question that if we can paste the result into a new sheet in case the current sheet is too large data?

This technique saved my whole day

Very Good explaination

Very helpful, thank you.

Very Good explaination