Forum Discussion

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
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..

Abiola1

MVP

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..