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?

Taidot: Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 4 arvostelua ) CROWS NEST, Australia

Projektin tunnus: #14687086

Myönnetty käyttäjälle:


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 1 päivässä
(272 Arvostelua)

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$70 USD 0 päivässä
(619 arvostelua)

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 Lisää

$60 USD 1 päivässä
(261 arvostelua)
$100 USD 1 päivässä
(250 arvostelua)

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 Lisää

$50 USD 1 päivässä
(180 arvostelua)

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 1 päivässä
(62 arvostelua)
$132 USD 3 päivässä
(35 arvostelua)

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 Lisää

$30 USD 1 päivässä
(3 arvostelua)

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. Lisää

$30 USD 0 päivässä
(7 arvostelua)
$111 USD 3 päivässä
(0 arvostelua)
$150 USD 5 päivässä
(0 arvostelua)

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 Lisää

$155 USD 3 päivässä
(0 arvostelua)
$155 USD 3 päivässä
(0 arvostelua)