Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Divide One Amount for Duplicates
I have an average of 3,000 rows with duplicated invoices. My excel sheets
reflects in each row the sold out inventory items for each invoice. Column A reflects the invoice number; column B the inventory items; Column C the quantities sold for each inventroy item and Column D the total shipping amount for the invoice. The total shipment amount is always reflected in each sold out inventory item. What is the formula to distribute the total shipment for an invoice to all the inventory item quantities for a particular invoice? I badly need HELP!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
Restrict input if amount is exceeded | Excel Worksheet Functions | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) |