Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine quantities of similar line items
I need a way to combine quantities of similar part numbers into one line item
rather than several line items of only a single quantity. I would like to turn this......: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 ........Into this: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 4 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine quantities of similar line items
I'd use data|Pivottable.
But if your data is sorted, using data|subtotals will get you kind of close. Joshua Hullender wrote: I need a way to combine quantities of similar part numbers into one line item rather than several line items of only a single quantity. I would like to turn this......: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 .......Into this: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 4 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine quantities of similar line items
Look at datafilteradvanced filter, select the part number range and select
unique records only and copy to another location -- Regards, Peo Sjoblom "Joshua Hullender" wrote in message ... I need a way to combine quantities of similar part numbers into one line item rather than several line items of only a single quantity. I would like to turn this......: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 D4DP6XY6AB 1 .......Into this: Part Number Qty. D4DP91SRAA 1 D4DP6XY6AB 4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
Combine candle and line in a single chart | Charts and Charting in Excel | |||
Combine candle and line in a single chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions |