Hi,
I'm using AVERAGEIFS to count specific data from a sheet using 3 criterea, however I also need to extract the actual data into another calculation, so instead of returning the average I want it to return the list of corisponding data against 3 selection criterea.
ie: I have a list of members who take part in diferent activities which get a score. I want to be able to lookup the member name with a specific activity and then extract the top 10 scores from their total list of scores.
So A1=surname;B1=forname;C1=activity type;D1=score
Everytime a member attends they get an entry for that day, the list has multiple member name entries.
I can obviously achieve the result by filtering then applying a calculation to the filtered result but I need it to be automated because there are a hell of alot of members.
Any suggestion would be welcomed.
Thanks Shaun
Bookmarks