That would not work. The reason why is because I am trying to match numbers
that will equal zero, then delete them once I have matched them. So what I
have been doing is sorting them, subtotalling them, and deleting all of them
that equal zero. But I would like to somehow get all of the transactions that
offset to zero together so I could delete them all at once.
"JMB" wrote:
Would it be better to remove the subtotals (Data/Subtotals/Remove All) then
sort/delete data, then re-apply the subototals?
"Rich" wrote:
Hello,
Does anyone know if you can sort a list after it has been subtotalled?
The reason I ask is because I am basically sorting a list based on a criteria
and then deleted all transactions that offset to each other to equal zero. So
if I could sort the list after it was subtotalled all the subtotalled amounts
that equaled zero would be in order and I could delete them all at once,
instead of scanning through the list. Any help would save me a huge amount of
time.
Thanks,
|