I have a spread-sheet that reports transactions from multiple vendors and then a balance. Any vendor that has a balance of zero i would like removed from the spreadsheet along with the corresponding rows of transactions. I have a few thousand rows with vendors and balances, but I only need to look at ones with a balance (either positive or negative), so removing vendors without a balance will clean up spreadsheet so it can be evaluated. See the attached example for specifics.
Transaction ID: 4NS81174KL2792718