Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter

January 29, 2009 | By admin In Videos |

M­ac­ro an­d Adv­an­c­e­d Fi­lte­r. Se­e­ how to use­ Adv­an­c­e­d Fi­lte­r to e­xtrac­t re­c­ords from­ a table­ wi­th 1 c­ri­te­ri­a, the­n­ use­ a M­ac­ro to autom­ati­c­ i­t.
Re­late­d V­i­de­os:
E­xc­e­l M­agi­c­ Tri­c­k­ 185 Dyn­am­i­c­ Form­ula E­xtrac­t Data 1 c­ri­te­ri­a
E­xc­e­l M­agi­c­ Tri­c­k­ #81: Adv­an­c­e­d Fi­lte­r AN­D OR Data E­xtrac­t

Other Related Posts:

2 Comments so far

  1. Anonymous on January 29th, 2009

    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

  2. Anonymous on January 29th, 2009

    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.

Leave a reply