merge same valu and total the amount indicated

G

geon12x

I have thousands of invoice most of them have the same invoice number. every
invc# contains crdt type and some of them are the same too but each of them
have the amount.

How to sort them to show no redunduncy of invoice and crdt type and the
amount will show only the total of each crdt type?
 
J

John Bundy

You should be able to do this by sorting by invoice number, then
Data->Subtotal and select at each change in invoice number, sum what you want
summed.
 
Top