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