Em Andamento

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.

Habilidades: Excel

Ver mais: 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

Acerca do Empregador:
( 15 comentários ) Amsterdam, Netherlands

ID do Projeto: #566829

Premiar a:

srinichal

This will be delivered

$30 USD em 1 dia
(3 Avaliações)
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 dias
(6 Comentários)
2.6
asaikiran1979

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

$40 USD em 1 dia
(5 Comentários)
2.1