Options

# Excel List, sum of duplicates? Solved

Registered User regular
edited May 2011
So I'm looking for a way to do this without having to make a list to find duplicates, then vlooking values, then another formula to find the sum.

I have a pivot table list of 1500 rows. Column A is item number column b is a number that lists how much dollar amount went in and out of inventory. The problem is that the inventory purchase and purge are not combined into the same value (IE 100 in 100 out, 0 is the value shown). Instead we have a line for item in and a line for item out.

Anyone got a protip to do this an easy way?

starmanbrand on

## Posts

• Options
Registered User regular
edited May 2011
So if it's in a pivot table, maybe I'm not envisioning this correctly:

Item 335, $300 Item 335, -$300
...etc

Is that how it looks? Wouldn't collapsing column A to summarize Item 335 show if the total is zero? Not sure I follow the layout properly here.

Bobble on
• Options
Registered User regular
edited May 2011
Thanks for the help. I figured out that the pivot table I was given was formatted in a weird way that prevented in from being collapsed like it normally would.

So I just made another pivot table. And then I got to discover that the data that its pulling from is useless for my purposes. Yaay.

Solved.

starmanbrand on