Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter
Macro and Advanced Filter. See how to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automatic it.
Related Videos:
Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteria
Excel Magic Trick #81: Advanced Filter AND OR Data Extract
Dear planiolro,
I am glad that they are useful!
Here is a video that shows the opposite of what you want to do:
Excel Magic Trick #152: Extract records w Field Not Blank
One way to do what you want is to add a new column to the data set with a formula with a relative cell reference that looks in the Purpose Field and asks “is it blanks?”. A formula like this would work:
purpose cell=”"
Then run Advanced Filter that looks for TRUEs.
–excelisfun
If the criteria is an empty cell how do I do?For instance I am interested in those individuals do not have anything in the purpose column! Anyway the video is more than interesting and useful in the same time. Tips as ctrl + * or clean the name manager after we use advenced filter are gold.