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 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.