The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Excel List, sum of duplicates? Solved
starmanbrand
Registered User regular
Registered User regular
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?
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
0
Posts
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.
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.