Advanced Filtering by top scores
Unfortunately I am in Excel XP (2002). Any solution for that version.
"Barb Reinhardt" wrote:
In Excel 2003
A1:A10 are the names
B1:B10 are the dates
C1:C10 are the scores
=AVERAGE(IF(A1:A10="Barb",IF(B1:B10=LARGE(B1:B10, 5),C1:C10)))
Commit with CTRL SHIFT ENTER.
--
HTH,
Barb Reinhardt
"kwh" wrote:
I am requiring filtering of a list of employees over a who are scored on
performance over a period of time. I would like to filter for the top five
most recent dates for each employee and average the scores for that filtered
data.
Is that possible in advanced filtering? If so, how is it done?
|