Excel Help

Completed Posted Mar 30, 2011 Paid on delivery

$30-250 USD

Paid on delivery

Completed Paid on delivery

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

Project ID: #1004429

About the project

2 proposals Remote project Active Mar 30, 2011

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Awarded to:

telemarketing555's Profile Picture
telemarketing555

Hi, please check your PM. Thank you.

$30 USD in 0 days
(22 Reviews)
4.4

2 freelancers are bidding on average $40 for this job

heamonto's Profile Picture
heamonto

Hi Check PM thanks

$50 USD in 1 day
(0 Reviews)
0.0
Post a project like this