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?
63 freelancers are bidding on average $90 for this 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!
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