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

Hello, you can use PivotTable to do that easily

JimDW2450

Copper Contributor

Mar 30, 2020

Abiola1

I have never used a pivot table can you point me to the right direction on a how to?

Abiola1
MVP
Mar 30, 2020
JimDW2450

To use the PivotTable:

1. Click inside the data

2. In the Insert tab, on the far left, click on PivotTable

3. In the PivotTable dialogue box, click on OK

In the PivotTable Fields, drag and drop Part Number inside Rows and Qty inside Values

That is all

If this answers your question, kindly accept as Best Response
- JimDW2450
  Copper Contributor
  Mar 30, 2020
  Abiola1
  When I follow your direction that is what I see and when I clock ok I get a message Data source reference is not valid.
  
  Im not sure what I am doing wrong?
  - Abiola1
    MVP
    Mar 30, 2020
    JimDW2450
    
    Hello, you didn't click inside your data which is the Step 1. That us why Table/Range was empty with the cell reference as seen below
    
    You need to click inside your data, either in the part number of quantity... Do that and let me know