please help to calculate how often a number appears and calculate total value

hi everyone

i need some help and im not sure how to word it so apologies if i dont make much sence

i have data from a stock take and it totals 798 row. using this data i need to see how offten the unique code appears in the data and then gather the total quantity from the next column. eg below

uniqe code -------------- quantity
4017267948919 ............. .10
4017267948777................7
4017267942222...... .....76
4017267948777................54
4017267948919 ...............55
4017267942222............3

would it be possible to get the result on a new sheet in the format of

unique code ................ . total
4017267942222.............79


once again thanks alot and any help would be greatly appricated


mukhtar