Need Help with Formula for Scoring Contestants in a competition

Hi,

I need help developing a formula for scoring contestants in a competition. I have an excel 2010 spreadsheet containing the number of each contestant (column C in the spreadsheet) and a score that has been assigned to the contestant's entry (score is in column I) from seven different scorers. Thus, for each contestant there are seven different rows in the spreadsheet, each containing the contestant's number in column C and the score given by one scorer in column I. My ideal formula will create a new row in a separate worksheet by querying the main worksheet to find all of the rows containing contestant number X in column C, subtracting the highest and lowest of the seven corresponding scores in column I, and then averaging the five remaining scores to get a total average score. So, for example, if contestant #1's scores are 100, 90, 80, 70, 60, 50, and 40, I want the formula to subtract (or just not count) the 100 and the 40, and then calculate the average of 90 + 80 + 70 + 60 + 50. I'd want the average score to be rounded to two decimal places (e.g. 60.25). Essentially, I want the second worksheet to contain a single row for each contestant consisting of two columns-- contestant number & total average score. What I want the formula to essentially say is "query worksheet 1, find the seven scores that are assigned to contestant #1, drop the highest score and the lowest score, then average the five remaining scores and output the contestant # in column A and the average score for that contestant in column B. THen, do the same for contestant # 2, 3, 4 ..." so on and so forth. Any help would be greatly appreciated. I am relatively tech savvy, but fairly new to developing formulas in Excel. Thanks in advance.

here is some sample data in a sample worksheet.

Thank you!