Compare Tables of Information - Create Sum VLookup and PivotTable Summary

$10-30 AUD

Concluído

Publicado

há quase 9 anos

$10-30 AUD

Pago na entrega

I have two tables, one that has a list of payments made post 1st July 2014 and the other table is a list of invoices pre 1 July 2014. I need to have the sales table cross-reference the payment table by order number to receive a sum of all payments post July 1 for those transactions in the table. I then need this summarised by: Outlet (two outlets) The sum Order Inc $ Value for each outlet where there were payments within the payments table. The sum of payments made against those invoices. Thank you for your considerations.

Data Entry

Data Processing

Excel

ID do Projeto: 7831556

Sobre o projeto

8 propostas

Projeto remoto

Ativo há 9 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@d2imatrix

Hi, We are experts in excel data processing. We have been working in analytics for last 10 years. If you can share your excel sample we can complete this quickly now. Regards, pal

$14 AUD em 1 dia

4,8

(14 avaliações)

4,7

8 freelancers estão ofertando em média $21 AUD for esse trabalho

@masud0012

A proposal has not yet been provided

$15 AUD em 1 dia

5,0

(52 avaliações)

5,0

@surekash7096

I have the expertise in Excel creating Pivot tables and automating with formulas or macros as required. Please give the specific details and it can be completed in a couple of hours based on the number of columns.

$25 AUD em 1 dia

5,0

(1 avaliação)

0,0

@afrestrepocastro

No problem I can do it very quick. I look forward to work with you. Please send the files to start working. Best, Andres

$25 AUD em 1 dia

0,0

(0 avaliações)

0,0

@pitahnix

I am an experienced writer. I can work for 30hrs/week, and I deliver work on time given. If you give me this job you will be satisfied with my work.

$15 AUD em 1 dia

0,0

(0 avaliações)

0,0

@nishkalt

Hi, I am a management professional with excellent skills in excel. The way the project is described it should not take more than 1 hour to finish the work. I can provide you the completed sheet within an hour with 100% accuracy. I can assure you that you would like to work with me again. regards Nishkal

$30 AUD em 1 dia

0,0

(0 avaliações)

0,0

@ankitexcel

I have 4+ industry Experience. I am doing lots of work in Excel,word,Data Processing,Data Analysis,Online Marketing,online Form filling ,etc. I can do your work with in your time limit. Thank You.

$20 AUD em 1 dia