Hi all,

I have an ever-changing list of data with names and scores. I want to match a name to one in the list and find the average of all scores for that particular name.

For example:

Name Y/N Score
Bill Y 90
Tom N 95
Sarah Y 72
Tom Y 89
David Y 90
Bill N 87
Sarah Y 87
Bill Y 93
David Y 88
Steph Y 97
Greg N 91

I want a function that will search all of Bill's scores and get the average for them. I then want the cell below that one to search all of Tom's scores and give me the average...and so on...

I've included an example spreadsheet as well.

Any help would be greatly appreciated.

Thank you in advance,

Seaottr

example.xlsx