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
Bookmarks