Microsoft Excel Pivot Table Solution

I am trying to come up with a pivot table solution.

• In the attached spreadsheet ‘Data’ tab, Columns R and S list the ‘Agent’ and ‘Co-agent’ involved

• As shown in the ‘Pivot’ tab, I would like to achieve the following:

o A unique list of Agent and Co-agent from columns R & S

o A sum of the ‘Agency Score’ column AB relating to each unique Agent/Co-agent

Is the above possible using standard pivot tables?

Habilidades: Excel

Veja mais: pivot table in excel, pivot table dashboard excel, pivot table vsto excel, convert attached spreadsheet html table, pivot table project excel, pivot table macro excel 2010, excel table pivot, create pivot table dynamically excel, excel 2007 table pivot table, pivot excel table, extract table mdb excel, singapore pivot excel, find table macro excel, vba excel lock columns refreshing sheet, create pivot excel net, convert table word excel, excel transform columns rows, net sql server table write excel pivot, excel convert columns rows

Acerca do Empregador:
( 4 comentários ) CROWS NEST, Australia

ID do Projeto: #14687086

Concedido a:


Hello, I’m an Excel expert and I would like to help you with your pivot tables. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.

$50 USD em 1 dia
(272 Comentários)

13 freelancers estão ofertando em média $99 para esse trabalho


Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on and have been featured by the freelancer community ( Mais

$70 USD in 0 dias
(619 Comentários)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement Relevant Skills and Experience I have the 5 years of ex Mais

$60 USD em 1 dia
(261 Comentários)
$100 USD em 1 dia
(250 Comentários)

Dear Sir/Madam, I can do this pivot task perfectly for you. I am one of the most trusted excel experts in this site, and have already done lots of similar projects for different clients. Tnx Relevant Skills and Ex Mais

$50 USD em 1 dia
(180 Comentários)

Hello, Please refer to your PM, I will follow all instructions and If you have any question related to budget, deadline of work and any other issue please let me know, Thanks

$200 USD em 1 dia
(62 Comentários)
$132 USD in 3 dias
(35 Comentários)

I write with passion, discernment, perception, and credibility which make me come up with the best result ever. Also, I deliver great results with a process that’s timely Stay tuned, I'm is still working on this pro Mais

$30 USD em 1 dia
(3 Comentários)

Hello, I've read your project description and understand what you are looking for. I'm sure you won't be disappointed when choosing me. You can see that I've finished some projects like yours with very good reviews. Mais

$30 USD in 0 dias
(7 Comentários)
$111 USD in 3 dias
(0 Comentários)
$150 USD in 5 dias
(0 Comentários)

I have 3 years of data handling experience with EXCEL sheet using VB macros. Developed macro to export data from excel sheet to .txt file.I am confident that I can finish this work. Relevant Skills and Experience EXCE Mais

$155 USD in 3 dias
(0 Comentários)
$155 USD in 3 dias
(0 Comentários)