New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

counting inventory with barcode scanner

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

counting inventory with barcode scanner

Postby Daniela » Wed May 08, 2013 1:25 pm

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
  • 0

Daniela
Rookie
 
Posts: 1
Joined: May 8, 2013
Reputation: 0
Excel Version: excel 2013

Re: counting inventory with barcode scanner

Postby Kevin UK » Wed May 08, 2013 4:52 pm

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
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016

Re: counting inventory with barcode scanner

Postby Sisyphus » Wed Nov 06, 2013 11:12 pm

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

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Re: counting inventory with barcode scanner

Postby mminor73 » Fri Jan 27, 2017 3:03 pm

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!
  • 0

mminor73
Rookie
 
Posts: 1
Joined: Jan 27, 2017
Reputation: 0
Excel Version: Excel 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 54 guests

cron