Excel Help

Hello,

If a number is duplicated in a specific range of column A (e.g.), I need to sum all the unique values of column B (e.g.) that are on the same row as the duplicate entry and list that value in the row where the "last" (down in the column) duplicate entry is situated. In the example below, the desired result of the aggregation in column c is 1147.

SC1063631 41

SC1063631 41

SC1063631 41

SC1063631 107

SC1063631 999 1147

Please see the attached file. I need it as a formula, but if there is no way doing it with a formula a VBA will also do the trick

Please let me know if you can do it in the next hour. I've spent 4 hours trying to resolve this.

Many thanks!!!

Excel

Projekt ID: #1004429

Om projektet