Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining duplicate records(rows)
I'm pulling sales per item, but sometimes the item number shows up twice with
two different sales numbers and I want to add the two sales numbers together and have that total sales under the one item number. Any ideas? |
#2
|
|||
|
|||
Pivot table perhaps, or sort your data on item number and then use data /
subtotals. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jen" wrote in message ... I'm pulling sales per item, but sometimes the item number shows up twice with two different sales numbers and I want to add the two sales numbers together and have that total sales under the one item number. Any ideas? |
#3
|
|||
|
|||
Isn't there a way to have excel analyze the data and combine the rows into
one row when the item number is the same and then adding the sales number in both rows together? "Ken Wright" wrote: Pivot table perhaps, or sort your data on item number and then use data / subtotals. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jen" wrote in message ... I'm pulling sales per item, but sometimes the item number shows up twice with two different sales numbers and I want to add the two sales numbers together and have that total sales under the one item number. Any ideas? |
#4
|
|||
|
|||
Yes, via a Pivot table or Data / Subtotals. Use either one to get what you
want and then if you really want to lose the detail data, just copy and paste special the table as values. Then delete the detail data. Failing that you need to use VBA to do what you want, though it would probably be quickest to have the VBA use a pivot table or data Subtotals and then give you a hardcoded output table and deleting the detail. A pivot table giving you what you want can probably be created from your data in literally 60 seconds - Likewise Data / Subtotals Pivot table intro http://peltiertech.com/Excel/Pivots/pivotstart.htm Data / Subtotals:- Sort all your data on the item number, select all the data, do Data / Subtotals - At each change in 'Iten Number', Sum - Tick all the fields you want to sum. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jen" wrote in message ... Isn't there a way to have excel analyze the data and combine the rows into one row when the item number is the same and then adding the sales number in both rows together? "Ken Wright" wrote: Pivot table perhaps, or sort your data on item number and then use data / subtotals. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Jen" wrote in message ... I'm pulling sales per item, but sometimes the item number shows up twice with two different sales numbers and I want to add the two sales numbers together and have that total sales under the one item number. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
find duplicate cells in Excel | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |