Hi,

I have the following data and would require help in calculating average % as
mentioned in below output.

We have huge data like this and it becomes difficult to calcualted it
manually using filter. Can some one help me with it?

Column A Column B Column C
Name Position Name Accuracy %
Namrata Ahuja Sr. Service Exec 80.00%
Neelam Sharma GWIM Exec 100.00%
Neha Juneja HR Manager 75.00%
Neha Juneja HR Manager 100.00%
Sundu Tamang Risk Analyst 99.63%
Sundu Tamang Marketing-Barclay 97.25%
Dilpreet K Nagi Market Writer 99.00%
Dilpreet K Nagi Market Writer 100.00%

Out put should be:

Column A Column B
Name Average Accuracy %
Namrata Ahuja 80.00%
Neelam Sharma 100.00%
Neha Juneja 87.50%
Sundu Tamang 98.44%
Dilpreet K Nagi 99.50%

Thanks in advance.

Regards,