using max ranges and match to reference cells to 3 highest numbers

I am trying to keep track of the best performances of players by position for my fantasy football league. I want to track the top 3 scores overall for quarterbacks, wide receivers, etc.

I have the formula to extract and highlight the top 3 scores, but I don't have the formula correct for tying in the player name, team and week.

I have a formula that uses 3 max ranges (given to me by someone else) and that only works for a small portion of the range. I need the ranges to cover F6:V503 (Columns F through V being 17 weeks of the season). Does each "max" only use one column? There are helper cells underneath.

I've attached the file.

Thanks for anyone that can help and explain what I've done incorrectly.

Damian

cell AC519 and copied down:

Please Login or Register  to view this content.

cell ad519 and copied down:

Please Login or Register  to view this content.

Not sure what the next column is supposed to do.

The next column is supposed to put in the date in which the score took place (F2:V2).

The formulas you just gave me work! Thank you!

I have posted a copy of the program with Eli Manning having the two highest scores of all quarterbacks in AB408 and AC408. The error in AC521 seems to show that it isn’t looking at the entire range of AB6:AD503.

Here's the file:

You're right that it was only looking at thefirst column. Unfortunately, MATCH only looks at one column. So the attached looks at each separately. Unfortunately, since a blank yields an error message, the formula gets a bit long. With Excel 2007 or higher, you can use IFERROR, which is shorter, but if you use 2003 you're stuck with this somewhat clunky solution.

Bentleybob,

You're fantastic. Thanks a ton!

Now if I could just get the date above the week the high scores took place to reference......

Kicker problem

Daddylonglegs,

You are a genius!

Thank you so very much!

Damian