In Progress

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?

Skills: Excel

See more: 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

About the Employer:
( 4 reviews ) CROWS NEST, Australia

Project ID: #14687086

Awarded to:

P0L

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 in 1 day
(182 Reviews)
6.7

16 freelancers are bidding on average $101 for this job

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view] More

$70 USD in 0 days
(482 Reviews)
8.0
$100 USD in 1 day
(249 Reviews)
7.6
schoudhary1553

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 More

$60 USD in 1 day
(180 Reviews)
7.0
priyal1997

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 More

$50 USD in 1 day
(158 Reviews)
6.6
andriphone0

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 in 1 day
(50 Reviews)
5.3
asadkhan3533

Hello, I can complete it right now for you. Please review my profile Relevant Skills and Experience Excel Proposed Milestones $111 USD - Excel Send me a message now so i can start working

$111 USD in 0 days
(20 Reviews)
4.5
$132 USD in 3 days
(10 Reviews)
4.1
beizhou23

We have many experience in Microsoft Excel including Excel [url removed, login to view] you see our portfolio and give us chance, We'll serve for you with high- quality & fast speed & satisfaction. Relevant Skills and Experience We are tea More

$150 USD in 3 days
(5 Reviews)
2.7
ExpertzWorld

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 More

$30 USD in 1 day
(3 Reviews)
2.5
VanshikaTulsyan

A proposal has not yet been provided

$55 USD in 2 days
(4 Reviews)
2.8
trangvt

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. More

$30 USD in 0 days
(6 Reviews)
1.7
$111 USD in 3 days
(0 Reviews)
0.0
$150 USD in 5 days
(0 Reviews)
0.0
savithaec

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 More

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0