I have a spreadsheet with 3 columns
Column A has barcode Numbers
Column B has the product name
Column C has the product QTY amount
I like to scan a barcode in column A starting at the 2nd row and if the barcode is listed in column A it will increase the QTY number by one in the correct barcode row in Column C.
I also like if the barcode is already listed in Column A is will not list it. (It will do nothing). I will just scan the next barcode.
The formula I have in Column C is “=COUNTIF(A2:A10,A2)”
I will send you my spreadsheet to show you what I have so far.
By: Derrell Dulin