Averages of different groups of data in a single sheet

I have a fairly large set of data on one sheet containing numbers for 60 different people. The data is set up similarly to the set below:

John Smith 75
John Smith 80
John Smith 62

Jane Doe 49
Jane Doe 89
Jane Doe 66

So on and so forth until the 60th person.
My question is: Is there a way to average the numbers for each different person at one time? What about median and mode as well? Do I need to set up a different sheet for that? Any help would be GREATLY appreciated!

Thanks

Pivot table with name and average of score

File is attached.

This was a HUGE help! Thank you!

IF u have a big list of names in column A then Copy the list and paste it in some column and then use the DELETE DUPLICATES in DATA option and then use the formula "Averageif(....) as shown in my attached file.

Hope u understood it.

Thank you for the help. One more question regarding the AVERAGEIF function: How do i exclude a specific data range? say, D14:D82 for example

Hi,

Made some modification .

Punnam

Hi,

First i am not madam i am sir .
I have updated the sheet with Index+Countif to list the name automatically .Check column D .

Punnam

Oh yes.. i didnt see the column D.. Thanks for sharing the knowledge.

u r welcome

punnam

@jpdickson
was u r question answered and solved if so mark the tread solved using the thread tools.
U can tank any one who have helped u by adding reputation point by clicking the star button .
Punnam