Need help with consolidation of data in Excel
I have a excel sheet with a feedback report based on the ticket which engineers worked. I want to analyze how many ‘N’ they have received against each point (Communication, Follow-up, Closure)
I have attached the sample sheet and the required result format. The result should be dynamic, means any changes in the input sheet reflect in the result.
Many thanks in advance for any assistance to resolve this query.
Sample Sheet
Required Result
Test.xlsx
I have attached the sample sheet and the required result format. The result should be dynamic, means any changes in the input sheet reflect in the result.
Many thanks in advance for any assistance to resolve this query.
Sample Sheet
Required Result
Test.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER