Create list of unique cells

I have a spreadsheet containing a column of numerical codes (A), some which repeat more than once in the column, and another column (B) of corresponding values for that code.

I need excel to build a new list (C) of each unique code that appears in column A, then to sum the corresponding values in B, in a new list (D).

Is this possible?
By: Sam

Leave a Reply

Your email address will not be published. Required fields are marked *