Excel Data Extraction or Sort/Filter/Extract Tool
EEPros,
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)?
Thank you,
B.
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)?
Thank you,
B.
ASKER
Phil..... I'm actually looking for a utility to do this for me rather then having to fix this every time. Will the Advanced Filter Function do that or do you know of a utility that presents a menu of options?
Much thanks,
B.
Much thanks,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys. I'll try to get use to using this advanced function filter. The video was very helpful.
B.
B.
Alternatively, use a helper column, which will have all of your criteria as a function giving a YES or NO at the end, e.g.
=if(and(d2=1,or(e2=2,e2=3)
and then filter on that column.