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?
64 freelancere byder i gennemsnit $89 for dette job
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!
Yes, this and more complex analysis can be done using Pivot tables. This will also allow you to update and add new information to the source table and you can update the pivot table to reflect the new data.
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