Fermé

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?

Compétences : Excel

Voir plus : 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, 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

Concernant l'employeur :
( 0 commentaires ) Indonesia

N° du projet : #14687281

65 freelance ont fait une offre moyenne de 89 $ pour ce travail

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus

155 $ USD en 3 jours
(173 Commentaires)
6.9
citijayamala

Expert in Excel pivot tables, Excel formulas, and all excel functions, macros, lookup concepts and pivot tables. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mark Plus

80 $ USD en 3 jours
(40 Commentaires)
5.0
50 $ USD en 1 jour
(18 Commentaires)
4.2
awaisjahangir25

Reviewed your file. let me know i can do this one. I’ve 5 years of experience in accounts, finance, bookkeeping, reporting, financial analysis and various other projects. I’ve also worked a lot on Quick Books and Ora Plus

50 $ USD en 1 jour
(11 Commentaires)
4.1
sheak

Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hearing from you soon. Thanks!

155 $ USD en 3 jours
(7 Commentaires)
4.0
humayoonsheikh4u

A proposal has not yet been provided

30 $ USD en 1 jour
(8 Commentaires)
3.9
gumadevi89

A proposal has not yet been provided

30 $ USD en 2 jours
(7 Commentaires)
3.0
ExpertzWorld

mecTo hire me directly, just copy and paste in your url "[url removed, login to view]" ................................................................................... “Time. It’s what we writers fig Plus

30 $ USD en 1 jour
(3 Commentaires)
2.5
dayakmlt

A proposal has not yet been provided

30 $ USD en 3 jours
(5 Commentaires)
2.0
30 $ USD en 3 jours
(7 Commentaires)
2.2
anmolmathcs

-Experience in Excel and Pivot tables. -100% error free work can be expected. -Quick turn around time.

40 $ USD en 3 jours
(3 Commentaires)
1.9
50 $ USD en 3 jours
(1 Commentaire)
0.8
brunovilela4219

A proposal has not yet been provided

35 $ USD en 0 jours
(1 Commentaire)
0.5
mrchambers

From your description I think a pivot table directly on the data should be feasible, but I'll need to see your Excel file to be sure. Please see attached "Excel Pivot Table [url removed, login to view]" (dropbox link below) for d Plus

80 $ USD en 3 jours
(0 Commentaires)
0.0
CesarHHC64

A proposal has not yet been provided

200 $ USD en 3 jours
(0 Commentaires)
0.0
40 $ USD en 1 jour
(0 Commentaires)
0.0
Luigi32

I've been working with spreadsheets everyday for years so i know what I'm talking about and pivot tables are one of my most used tools as they are very powerful

155 $ USD en 3 jours
(0 Commentaires)
0.0
Bwiker

I am very experienced in data analytics. I didn't see your spreadsheet but I believe you are very close to having what you need. I would create a unique field in your data tab that auto combines the Agent and Co Agen Plus

55 $ USD en 1 jour
(0 Commentaires)
0.0
humvale

Good evening, Sir. I have a substantial working experience using pivot tables, data extraction techniques, and data analysis for business purposes. I would be glad to work on your project. Your satisfaction is guarant Plus

55 $ USD en 2 jours
(0 Commentaires)
0.0
Amyrenea

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0