I have a spreadsheet with 10 columns of data and approx. 5,000 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.
Bookmarks