Lukket

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?

Færdigheder: Excel

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

Om arbejdsgiveren:
( 0 bedømmelser ) Indonesia

Projekt-ID: #14687281

65 freelancere byder i gennemsnit $89 for dette job

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 Mere

$155 USD in 3 dage
(173 bedømmelser)
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 Mere

$80 USD in 3 dage
(40 bedømmelser)
5.0
$50 USD på 1 dag
(18 bedømmelser)
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 Mere

$50 USD på 1 dag
(11 bedømmelser)
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 in 3 dage
(7 bedømmelser)
4.0
humayoonsheikh4u

A proposal has not yet been provided

$30 USD på 1 dag
(8 bedømmelser)
3.9
gumadevi89

A proposal has not yet been provided

$30 USD in 2 dage
(7 bedømmelser)
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 Mere

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

A proposal has not yet been provided

$30 USD in 3 dage
(5 bedømmelser)
2.0
$30 USD in 3 dage
(7 bedømmelser)
2.2
anmolmathcs

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

$40 USD in 3 dage
(3 bedømmelser)
1.9
$50 USD in 3 dage
(1 bedømmelse)
0.8
brunovilela4219

A proposal has not yet been provided

$35 USD in 0 dage
(1 bedømmelse)
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 Mere

$80 USD in 3 dage
(0 bedømmelser)
0.0
CesarHHC64

A proposal has not yet been provided

$200 USD in 3 dage
(0 bedømmelser)
0.0
$40 USD på 1 dag
(0 bedømmelser)
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 in 3 dage
(0 bedømmelser)
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 Mere

$55 USD på 1 dag
(0 bedømmelser)
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 Mere

$55 USD in 2 dage
(0 bedømmelser)
0.0
Amyrenea

A proposal has not yet been provided

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