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?

Evner: Excel

Se mere: 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

Om arbejdsgiveren:
( 4 bedømmelser ) CROWS NEST, Australia

Projekt ID: #14687086

Tildelt til:


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 på 1 dag
(253 bedømmelser)

14 freelancere byder i gennemsnit $100 på dette job


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 Flere

$70 USD in 0 dage
(560 bedømmelser)

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 Flere

$60 USD på 1 dag
(224 bedømmelser)
$100 USD på 1 dag
(249 bedømmelser)

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 Flere

$50 USD på 1 dag
(178 bedømmelser)

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 på 1 dag
(59 bedømmelser)

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 dage
(39 bedømmelser)
$132 USD in 3 dage
(24 bedømmelser)

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 Flere

$30 USD på 1 dag
(3 bedømmelser)

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

$30 USD in 0 dage
(7 bedømmelser)
$111 USD in 3 dage
(0 bedømmelser)
$150 USD in 5 dage
(0 bedømmelser)

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 Flere

$155 USD in 3 dage
(0 bedømmelser)
$155 USD in 3 dage
(0 bedømmelser)