Forum Discussion

JimDW2450's avatar
JimDW2450
Copper Contributor
Mar 30, 2020
Solved

Count Numbers and Quantities

I have Column A that has multiple duplicate part numbers Column B shows a QTY for that part number   I want to remove duplicates but count the quantities, so for example   Part Number     QTY A ...
excel
Formulas and Functions
  • Abiola1's avatar
    Abiola1
    Mar 30, 2020

    JimDW2450

    In my example below, you can see that I am currently in cell A1. Hence, in my Create PivotTable box, the cell reference is visible.. 

     

     

Resources