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

Category:

Science & Technology

Tags:

• Excel
• Advanced
• Filter
• Macro
• to
• extract
• records
• from
• table
• with
• criteria
• Gel
• Girvin
• Highline
• Community
• College

[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!!

[goforityay]

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

[ExcelIsFun]

I am glad that you like the videos!

[GabiRav]

Great Video!!!

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

[ExcelIsFun]

You are welcome!

[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.