Excel Magic Trick 1244


Transform GDP Data Set: Advanced Filter with Formula Criteria wins!
From Bill Szysz at YouTube, see how to use a Formula in Criteria area of Advanced Filter to extract data based on three conditions from a large data set of GDP data:
(00:07) Introduction to past videos about this topic
(00:40) Explanation of complex criteria for extract data from large data set.
(01:53) Helper Column with formula that uses AND, SEARCH, ISNUMBER functions and a Boolean Logical Test to “show” us what Advanced Filter does when it uses a Logical Formula as its criteria for extracting records.
(05:06) Advanced Filter with Criteria area that uses a Formula and the Copy to textbox to limit the fields extracted from the original data set