1. N

    Formula for subtotal with conditions, in Pivot with Calculation - Fields (Pivot - Analyze - Calculation - Fields - subtotal by condition IF or SUMIF)

    This is Pivot table. Field1 is counted as Bottle price / Volume. But Subtotal for Field 1 is wrong. 21,2654321 is wrong answer, watching data, we understand that price of Bottle per Lt is 65. For some reason, Field 1 is taking all volume. Perfect Formula would look like this...
  2. N

    Extracting Specific Text from a Cell

    Hi all, How can I pull out specific text from a cell, for example if I have the following Budweiser 12pk Bottle 12oz Yeungling 6pk Can 12oz Heineken Keg 13.2gal Stella 12pk Bottle 18oz in the column after this I want to be able to extract whether it is a can, bottle or keg. Thanks
  3. S

    newbie here.

    I'm sure this has been addressed before on theses boards but I figured I would try asking before searching. I work at a small children's hospital with limited resources and we need to come up with a simple inventory system. This is what I want. Another department calls for a bottle of...
  4. F

    Subtracting until zero then taking remainder from another cell.

    Hi all, I am having a problem thinking of formula to calculate my wine stock with Excel 2013. Here is an example: <tbody> Wine Name Opening Stock Bottles Total Sales Closing Stock Glass Bottle Total Received Glass Bottle total Glass Bottle total Wine 1 0.0 1.0 1.0 0.0 1.0 0.4 0.0 0.6...

Some videos you may like

This Week's Hot Topics