Invoicing through excel

[Kagz01]

I have working formulas to pull data and price from database per upc code that has been scanned and entered into the cell.

What is happenning is when i scan a barcode more than once i have multiple lines with the same information. What i would like for excel to do is instead of having multiple line with the same product, delete the multiples and add to quantity colum.

Item. Quantity -----> Item. Quantity
1. 1. 1. 2
1. 1. 2. 3
2. 2
2. 2
2. 2

 

[shg]

	A​	B​	C​
1​	Scan​	Qty​	​
2​	1. 1. 1. 2	1​	B2: =IF(COUNTIF(A$1:A2, A2) > 1, "", COUNTIF($A$1:$A$6, A2))
3​	1. 1. 2. 3	1​
4​	2. 2	3​
5​	2. 2
6​	2. 2

 

[Kagz01]

	A​	B​	C​
1​	Scan​	Qty​
2​	1. 1. 1. 2	1​	B2: =IF(COUNTIF(A$1:A2, A2) > 1, "", COUNTIF($A$1:$A$6, A2))
3​	1. 1. 2. 3	1​
4​	2. 2	3​
5​	2. 2
6​	2. 2

<tbody>
</tbody>

shg, I appreciate the quick reply! However the provided solution doesnt solve my issue. Im not even sure it can be done but im trying hard to find out.

If a second or subsequent cell is entered with the same information, I want that cell to clear and add to the qty. each item will have its own row

Item QTY into this ----> ITEM QTY
1 1 1 4
1 1 2 2
1 1 3 4
1 1
2 1
2 1
3 1
3 1
3 1
3 1

 

[Kagz01]

im sorry its changing it

FROM:
ITEM QTY
1 1
1 1
1 1
2 2
2 2
3 3
3 3

TO:
ITEM QTY
1 3
2 2
3 2

 

[Kagz01]

i hope this works...
This is what it currently looks like..........................................This is what i want excell to do with the information
ITEM........QTY..............................................................................ITEM.............QTY
1...............1.................................................................................1..................2
1...............1.................................................................................2..................3
2...............1......................................................................................................
2...............1......................................................................................................
2...............1......................................................................................................

 

[shg]

It puts the quantity at the first appearance of the item,

	A​	B​	C​
1​	Item​	Qty​	​
2​	2​	2​	B2: =IF(COUNTIF(A$1:A2, A2) > 1, "", COUNTIF(A:A, A2))
3​	8​	4​
4​	2​
5​	3​	2​
6​	7​	6​
7​	8​
8​	8​
9​	7​
10​	10​	2​
11​	8​
12​	10​
13​	4​	1​
14​	9​	3​
15​	7​
16​	6​	1​
17​	3​
18​	1​	2​
19​	7​
20​	7​
21​	9​
22​	9​
23​	1​
24​	7​

You can filter to hide the null strings in col B.

 

[Kagz01]

That will be perfect I can reference the cells on my main sheet and it will keep track of everything. Can I get excel to hide a row that does not have a value in column B Or a value less than one?

 

[shg]

Select those two columns, Data > Filter, click the dropdown in B2, follow your nose ...