Excel guru's

[jewozzy]

I want to make a spreadsheet that fills one column with numbers from a barcode scanner then takes all of those scans and creates a second column with the unique scans then totals them next to the unique column. I already know how to get the totals and I know how to do advanced filtering but I want/need something automatic. It will be for inventory purposes and doesn't need to be pretty I just want something automatic.

[YALE]

You could enter every scan in one column, and make a pivot table based on what you're looking for, or use an if/sum function or even vlookup, but a better choice would be buying some form of inventory control software that lets you enter a UPC, then edit details and quantity about that UPC.

[lincolnboy]

You mean column ex. C1 would be =a1+b1 and that would be the sum of both scans?

[Strychnine]

You mean column ex. C1 would be =a1+b1 and that would be the sum of both scans?

Just seeing you use the word "sum" makes me feel like we're being trolled 99% of the time and that you occasionally slip up and forget to be a retard.

[jewozzy]

You could enter every scan in one column, and make a pivot table based on what you're looking for, or use an if/sum function or even vlookup, but a better choice would be buying some form of inventory control software that lets you enter a UPC, then edit details and quantity about that UPC.

Every scan is currently going to column A then in column C I'm doing advanced filtering for uniques and column D is taking the total scans from A and putting the totals next to the unique. My main problem is finding how to automatically populate column C with all uniques from column A.

[Rafa]

Maybe setup a macro and choose a "hot" key to run it??

[Nash B.]

http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/

[jewozzy]

http://www.get-digital-help.com/2009...om-one-column/

ive tried a few of them but because i want it to scan the entire column i kept getting errors. though there is a possibility i wasn't doing it right.

[Nash B.]

What errors?

[jewozzy]

ill take a screen shot monday.