Help with stock take - multiple listings of part numbers that need to be accumulated

[Jasondn78]

Hi Guys (newbie here)

Need some help with a barcode scanning issue. Doing stock take real soon and I have quantities and part numbers as listed in the sheet attached. There are numerous part numbers that will be the same but scanned individually. I need to create a list that represents each part number once and that adds up all the quantities together. eg.

Part - Quantity

53996040 1
53774220 4
53996040 1
53884221 1
53996040 1

Needs to be:

53774220 4
53884221 1
53996040 3

Your help will be appreciated!

JasonHelp Required.xlsx

[oeldere]

That's a job for pivot table.

See the attached file.

[Jasondn78]

Thanks very much! Just the answer I was looking for.

[Jasondn78]

That's a job for pivot table.

See the attached file.

Can you help me out with the variance report?

[oeldere]

If you will explain what you mean with:

variance report

I will take a look for you.

[Jasondn78]

Help Required Variance Report.xlsx

Thanks very much! Basically with the stock take, you have quantities on hand, counted and variances (differences) which are either +, - or =. My on hand quantity might be 10, but I count only 6 which means there is a variance of -4. You could also count items which was not in your starting stock as well. Please see the spreadsheet attached and let me know. Danke

[oeldere]

Maybe you can also add the desired (expected) result in your sheet.

[Jasondn78]

Here we go - bit of copy & paste, but I think you will get the idea. Thanks again

[oeldere]

Don't find the differance (yet).

But if you re-arange your data you could use pivot table to sum your data.

See the attached file.