Multiple Column filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set up a filter to sort by 1 column and then within that
column, delete unwanted rows according to vlaues in another column? For
example, I want to only see the rows that have a value of "B" in col A and of
those records, I only want those with the value of "B" that are greater than
4000. Make sense?
 
If you apply data|filter|autofilter to the complete range (including those 2
columns), you can filter to show "B" in column A and filter the second column to
show the cells with values >4000.
 
Once you bring the data into excel, it doesn't matter what it was originally.

If you want to keep formatting/formulas/page breaks and that kind of stuff, it
will matter how you save the file. If you save it as a .csv file, then those
things will be lost. .CSV files are plain text.

And you can apply data|filter|autofilter to the range.

Then you can apply any set of filters you want.

You can reset all the filters by using:
data|filter|show all

(Or reset each filter in each column one by one.)
 
Is there a way to retain the results from the first filter and then run the
second? I have a column with 20 criteria, some criteria should be >4000,
some should be >5000 and others should be deleted altogether. I know I need
to use a macro but each time I seem to only end up with the information from
the last filter. Is there a way to do this with a macro?
 
I like to show all the data between using different filters (if I don't want to
keep that existing criteria).

With Worksheets("sheet999")
If .FilterMode Then
.ShowAllData
End If
'apply the filter criteria that you want.
End With

I'm not sure what should happen between filterings though.
Is there a way to retain the results from the first filter and then run the
second? I have a column with 20 criteria, some criteria should be >4000,
some should be >5000 and others should be deleted altogether. I know I need
to use a macro but each time I seem to only end up with the information from
the last filter. Is there a way to do this with a macro?
Click to expand...
 
Back
Top