We help IT Professionals succeed at work.

filtering data

is it possible to filter an Excel csv file with 2 columns and save the result as another name?
Comment
Watch Question

Rob HensonFinance Analyst

Commented:
When a filter is in place, doing a copy and paste will only copy the visible items.

So to answer your question, yes it is possible. Apply a filter, copy the result to a new workbook, save that workbook as new file.

Author

Commented:

Thanks If I enforce a filter on one column, it appears that I'm losing the filter when I moved and chose my next filter column. 

Rob HensonFinance Analyst

Commented:
Select all the data or at least all the headings before applying the Auto Filter. You will then get a dropdown against each header with the filter options.

When you filter on one column, the available filter options for subsequent columns will only show the values which are still visible from first filter.

Author

Commented:

So if I have 2 columns in a spreadsheet and  I want to use as filters eg. Active and ProductActive and the ideal situation is If I marked PartActive = True, ProductActive should be True as a rule . Both should have true values. But what if  certain ProductActive rows  were not marked as True but it should be True, what is the safest way to it-Filter by ProductActive first then Active?  If express in an SQL query ,  it should be something like 

"If Active = True AND ProductActive = True..." This is the type  filter test I  have in mind...

Using AutoFilter effectively applies AND conditions, eg Filter 1 = Criteria1 AND Filter 2 = Criteria2

If you filter on Column 1 for TRUE, if I understand correctly in the ideal scenario the only option in column 2 should then also be TRUE. If there is a FALSE option then some of the TRUE lines from column 1 have a FALSE in column 2. Selecting FALSE in column 2 would then show those lines.