Microsoft Excel Pivot Table Solution

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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?

Excel

Project ID: #14687086

About the project

12 proposals Remote project Active 6 years ago

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
(464 Reviews)
7.9

12 freelancers are bidding on average $105 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
(809 Reviews)
8.8
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
(384 Reviews)
8.2
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
(185 Reviews)
6.7
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
(76 Reviews)
5.9
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
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