merge same valu and total the amount indicated
 

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?

merge same valu and total the amount indicated
 

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"geon12x" wrote:

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?