Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter

[GabiRav]

Great Video!!!

It three years ago and I am waiting for many such sophisticated excel video.

[nshaik20]

Superb vedio..............Excellent, expecting more tech...........Thank you for crystal clear explanation

[ExcelIsFun]

You are welcome. This video goes into even more detail:

Highline Excel Class 19: Advanced Filter Extract Data 9 Examples

[samueljones79]

Thanks, I've been trying to remeber how to do this for like the last hour.

[ExcelIsFun]

You are welcome!!

[ExcelIsFun]

You are welcome!

[goforityay]

haha you're so lively i love your videos =)

[ExcelIsFun]

I am glad that you like the videos!

[vivianmark]

Thank you for the videos. Loving it.

Here is a tip for 185.6

You can selectively select which column you want to filter (copy) over.

Scenario: Only Employee column extracted.

Tips: Just do the same as usual with Advance Filter. The difference is, copy-to-destination has only the Employee column name. i.e. Remove Date, Dep, Purpose and Cost columns on right hand side table.

[planiolro]

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.

[ExcelIsFun]

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