1 | J Leader
ID: 49346417 Thu, Jul 01, 2004, 09:20
|
you could add a column C to sheet 1 with "rank". The you can rank everyone's average. Actually, I guess you'd need to rank em in column A.
Then in Sheet 2, you can lookup the averages based on ranks 1, 2, & 3. (As long as there are no ties, you should be ok)
|