| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you merge a dollar amount into a word doc and keep the $? | Excel Worksheet Functions | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| need a formula to get the total $ amount | Excel Discussion (Misc queries) | |||
| having a set $ amount be deducted from any given total | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Hybrid Mode
