C
CYB
I need help 
The data in my spreadsheet is organized as shown below with each numbe
representing a column
1. Customer Name
2. Name of Customer's Company
3. Name of specific project with customer (for simplicity think Projec
x, Project y...)
4. Internal Consultant assigned to specific engagement (Jim, Jane...)
5. Customer satisfaction rating with our company (Good, Very Good...)
My problem is that I need to sort the data in various ways and I a
running into a double counting issue. For example, three interna
consultants may be assigned to Project x and the customer satisfactio
rating is poor. And on Project y, seven internal consultants wer
assigned and the customer rated satisfaction as Very Good. When lookin
at overall rating of our company it becomes weighted on the project
with more internal consultants assigned and thus incorrect.
But I also need to keep the internal consultants attached to eac
project because I want to see satisfaction ratings of all projects pe
consultant as well.
Any help would be greatly appreciated and please let me know if yo
need more clarification
The data in my spreadsheet is organized as shown below with each numbe
representing a column
1. Customer Name
2. Name of Customer's Company
3. Name of specific project with customer (for simplicity think Projec
x, Project y...)
4. Internal Consultant assigned to specific engagement (Jim, Jane...)
5. Customer satisfaction rating with our company (Good, Very Good...)
My problem is that I need to sort the data in various ways and I a
running into a double counting issue. For example, three interna
consultants may be assigned to Project x and the customer satisfactio
rating is poor. And on Project y, seven internal consultants wer
assigned and the customer rated satisfaction as Very Good. When lookin
at overall rating of our company it becomes weighted on the project
with more internal consultants assigned and thus incorrect.
But I also need to keep the internal consultants attached to eac
project because I want to see satisfaction ratings of all projects pe
consultant as well.
Any help would be greatly appreciated and please let me know if yo
need more clarification