counting inventory with barcode scanner

[Daniela]

I want excel to recognize the same barcode when i scanned it and just add it to quantity not duplicate, can someone knows how can I do that, Thank You.
For example
barcode quantity
001233 1
001233 1
012444 1
012444 1

What do I have to do in order to excel recognize the barcode and add it instead of repeating the same barcode.
I want it to look like this
Barcode quantity
012333 2
012444 2

[Kevin UK]

Hi Daniela

For your example and assuming the data is in A1:B5, including column headers. In cell D2, put the following formula and copy down. Not in row 1.

Code: Select all

=IFERROR(INDEX($A$2:$A$1000,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$1000),0,0),0)),"")

Then in E2 and copy down.

Code: Select all

=COUNTIF($A$2:$A$5,D2)

Kevin

[Sisyphus]

There are a number of threads on this forum where this subject was successfully dealt with. However, bear in mind that Excel doesn't have the capability to write anything to any cell. What it is good at is to display things in a cell which aren't there, for example results of calculations. If you have a cell in which a number is already written and you wish to replace that number with another (incremented by 1, for example) a worksheet function can't help. You either have to enter the number yourself or get VBA to do it for you. Therefore, the above mentioned solutions are all VBA based and you will find them on the forum for VBA and Macros.
Enter "barcode" in the search field and study the threads that come up. One of them can surely be modified to do exactly what you want.

[mminor73]

Hello everyone hope all is good
I need help trying to figure out how to use my bar code scanner just to count the scanned items separate . Scan one as many times with the count move to the next item scan and count. Is there a way to formulate my cells to do that? I am in need of help thanks again!