Excel 2010 combining data

[kraser]

hi,

its probably very basic but i can seem to get it right.

im plan on doing some stock checks:

so in column A i have all the barcode numbers that I've scanned.

Column B i have the number 1 appear when information is entered in Column A as its a single item i scanned. Cell B1 has if(a1>0,1)

i have duplicate items that all say 1. is there away of excel realising theres two of the same barcode and put a 2 (or how ever many i scanned of the same item)? id prefer it if i could get the new consolidated figure in sheet 2

Thanks

[Namchan]

Well i dont have much idea about doing this or any kind of formula such stuffs in Excel. But while searching for some solution i found a thread here. I think it will help. Check this:
How to combine data in duplicate rows in MS excel