Excel Data Extraction or Sort/Filter/Extract Tool
Posted on 2015-01-13
I have a Excel WS where I need to extract a set of records based on a multitude of criteria (i.e. Filter multiple columns, sort, etc.). Right now I'm using a filter, then another filter, then another filter and it's not giving me the and/or capabilities I need to get to my data. Is there a technique or utility (pivot table??) in Excel 2010 or a reasonably priced "add-in" or complementary product that would give me a far more advanced capability to extract the data I need (i.e. something similar to the ETL capabilities in SPSS)?