Excel 2007 : Determining which action had highest average score

Hi,

I hope you can help me figure out how to do this. I want Excel to pull the text string that had the highest associated average score for a certain actor and display it. Sound simple? Well it isn't I think

So here's the scenario:

• 50 people assigned an ID 1-50
• 1500+ different actions which are text
• Satisfaction with an action ranked 0-10

What I would like to do is this:

1. Reference a cell which contains the ID (1-50) for a given actor (already done)
2. Then average all satisfaction scores per action for this actor (i.e. Jumping has 3 entries for the actor, rated 0, 6, 9, average that keeping in mind there's a host of different actions)
3. Return the name of the action with the highest average in cell A
4. Return the average value of the action in cell B
5. Return the number of this action counted in cell C

Repeat for the next 4 highest averages top create a top5 highest average list of actions.

Please let me know if I need to clarify this further!

P.S.:
ID (actor reference) is already given on the current worksheet. It references AS:AS of Sheet1. The ID can be changed on the current worksheet to produce a report for different actors on the current worksheet. This is already in place.
Action is found on D:D of Sheet1
Satisfaction score is found on H:H of Sheet1

ReportTest2.xlsx