Microsoft Excel Pivot Table Solution

In Progress

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, 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, create pivot excel net, convert table word excel, net sql server table write excel pivot

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
(168 Reviews)
6.6

17 freelancers are bidding on average $100 for this job

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More

$70 USD in 0 days
(473 Reviews)
7.9
$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
(171 Reviews)
6.8
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.5
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
(48 Reviews)
5.3
$132 USD in 3 days
(6 Reviews)
4.1
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
(13 Reviews)
4.1
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
beizhou23

We have many experience in Microsoft Excel including Excel VBA.If 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
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.6
$88 USD in 2 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$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