Hi,


I have assumed your data are in columns A.B and C
Select your list of names then
Data|Filter|Advanced filter
Selecr 'Copy to new location
Check 'Unique values only'
Enter an address to copy to (I used K1)
Click OK

Yoou will get a unique list in K1 down
enter this in L1 and drag down
=AVERAGE(IF($A$2:$A$10=K1,$C$2:$C$10,FALSE))

This is an array formula and must be entered woth CTRL+Shift+Enter and not
just enter. If you do it correctly Excel will put curly brackets around it
{}. You can't type these yourself

Mike
"Uma Nandan" wrote:

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,