EXCEL - Add rows with certain unique value in column

We regularly receive Excel sheets from one of our service providers. These sheets contain account data.

In column A unique customers are identified. Each row represents an investment they have. What we want is an addition of all rows belonging to an individual customer. The results should be pasted in a new sheet.

As you can see in the attached sample, customer IDs are in column A. Column M should be added (per client). Date in column B should also be kept. The rest can be ignored.

So Sheet1 remains unchanged. Sheet 2 has the results with Col A UserID, Col B date and Col C sum of investments.

Sheet 3 should be a summation of column M per unique value in Column Q. (This is a summation of investments per investment type, not per customer.) In this sheet Col A should be Fund Code (col P), Col B should be the date and Col C should be the sum of investments.

Please provide a macro that demonstrates this function in the attached sample. Do not password protect the macro.

Skills: Excel

See more: excel unique value column, excel column unique value, addition certain rows excel, excel add rows, we excel, sheets add, function sheet sample, sum sheets certain value column, what is macro in excel, summation excel, new excel, excel summation, customer data in excel, Value, value added service, rows, row b, P&IDs, macro excel, macro + excel, m@sum, investments, excel service, excel password, excel function

About the Employer:
( 15 reviews ) Amsterdam, Netherlands

Project ID: #566829

Awarded to:


This will be delivered

$30 USD in 1 day
(3 Reviews)

3 freelancers are bidding on average $33 for this job


Hello, I can do this job for you quickly and in the high quality. Please contact with me if you are interested in my suggestion. Thanks.

$30 USD in 3 days
(6 Reviews)

Hi, Please see my PMB. Thank you, Kiran.

$40 USD in 1 day
(5 Reviews)