Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Totaling & Subtotaling duplicate rows.
Hi,
I have a spreadsheet with multiple columns of data for stocks held by different customers. The 3 main columns are the customer name, the stock amount and stock currency. I sort the data by currency first then by customer name. I am trying to insert a blank line and total by customer per currency, and have a grand total at the end. I used the subtotals option in data menu bar, by recording a macro and attaching it to my existing code, but this does not split the customers by the currencies properly. If i have the same customer twice it totals both currencies together. Can anyone help me with the code to fix this please? Thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying and totaling up duplicate cells in Excel | Excel Worksheet Functions | |||
Subtotaling across columns rather than rows | Excel Discussion (Misc queries) | |||
totaling rows | New Users to Excel | |||
Totaling columns in a row with duplicate data - Pivot Table?? | Excel Worksheet Functions | |||
Totaling rows of text | Excel Worksheet Functions |