I gang

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

Færdigheder: Excel

Se mere: me excel, excel vba formula, excel vba help, excel help formula, need excel help, vba e, vba 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, excel column unique value, vba excel range

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

Projekt-ID: #1004429

Tildelt til:

telemarketing555

Hi, please check your PM. Thank you.

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

2 freelancere byder i gennemsnit $40 for dette job

heamonto

Hi Check PM thanks

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