Filtering, Sorting and Then Sub-Totalling

[wilderfan]

I have a spreadsheet with 10 columns of data and approx. 5000 records.

I want to filter the records based on 2 of the columns - which I have done.

Then I plan to sort the remaining records (based on the contents of a 3rd column).

Finally, I want to sub-total the "Amount" column (Column #10), every time the contents of the 3rd (sorted) column changes.


QUESTION: Is there an easy way to remove the filtered records so that my sub-totalling doesn't get derailed ?

Right now, the hidden (filtered) records are causing problems with the sub-totalling.

 

[Brianwarnock]

I think that you would have to use the copy to option of the advanced filter.

Brian