Excel Help


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

Evner: Excel

Se mere: me excel, i need excel help, excel vba formula, excel vba help, excel help formula, need excel help, vba excel, vba e, VBA and excel, trick, row b, excel formula, excel duplicate, excel 2011 vba, excel specific, excel row column, excel trick, vba help, excel unique, excel column row, vba excel 2011, vba file list excel, vba 2011, column row excel, hour excel

Om arbejdsgiveren:
( 6 bedømmelser ) Brookline, United States

Projekt ID: #1004429

Tildelt til:


Hi, please check your PM. Thank you.

$30 USD in 0 dage
(22 bedømmelser)

2 freelancere byder i gennemsnit $40 på dette job


Hi Check PM thanks

$50 USD på 1 dag
(0 bedømmelser)