In Progress

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, summation excel, new excel, excel summation, customer data excel, value, value added service, rows, row b, macro excel, investments, excel service, excel function, excel add, do excel, column, rest service data, excel macro add, excel row column

About the Employer:
( 15 reviews ) Amsterdam, Netherlands

Project ID: #566829

Awarded to:

srinichal

This will be delivered

$30 USD in 1 day
(3 Reviews)
4.4

3 freelancers are bidding on average $33 for this job

waster

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)
2.6
asaikiran1979

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

$40 USD in 1 day
(5 Reviews)
2.1