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

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
  - JimDW2450
    Copper Contributor
    Mar 30, 2020
    Abiola1
    
    Thank you that worked!