As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

Excel List, sum of duplicates? Solved

starmanbrandstarmanbrand Registered User regular
edited May 2011 in Help / Advice Forum
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?

camo_sig2.png
starmanbrand on

Posts

  • Options
    BobbleBobble 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
    starmanbrandstarmanbrand 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
    camo_sig2.png
Sign In or Register to comment.