Multiple Column filters
 

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?

Multiple Column filters
 

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.



Kristinf wrote:

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?

--

Dave Peterson

Multiple Column filters
 

Can I do this for multiple values within the same spreadsheet? (Value b
=4000, value c =5000, etc) Also, does it matter if its a csv worksheet?

"Dave Peterson" wrote:

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.



Kristinf wrote:

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?

--

Dave Peterson

Multiple Column filters
 

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.)

Kristinf wrote:

Can I do this for multiple values within the same spreadsheet? (Value b
=4000, value c =5000, etc) Also, does it matter if its a csv worksheet?

"Dave Peterson" wrote:

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.



Kristinf wrote:

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?

--

Dave Peterson


--

Dave Peterson

Multiple Column filters
 

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?

"Dave Peterson" wrote:

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.)

Kristinf wrote:

Can I do this for multiple values within the same spreadsheet? (Value b
=4000, value c =5000, etc) Also, does it matter if its a csv worksheet?

"Dave Peterson" wrote:

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.



Kristinf wrote:

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?

--

Dave Peterson


--

Dave Peterson

Multiple Column filters
 

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.

Kristinf wrote:

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?

"Dave Peterson" wrote:

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.)

Kristinf wrote:

Can I do this for multiple values within the same spreadsheet? (Value b
=4000, value c =5000, etc) Also, does it matter if its a csv worksheet?

"Dave Peterson" wrote:

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.



Kristinf wrote:

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?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson