Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I know some have helped on this before, but I cant seem to get it right.
Heres what I have A Name Age Time Score B Bob 8 12.2 56 C Sue 12 13 72 etc NAME is in column C AGE in column D There are only three ages 8, 10 and 12 TIME in column K SCORE in column L There is some unimportant info in the other columns I would like to have it show me the highest four scores in each age group, for a total of 12. I would like this to be a function, not resort the whole list, so it is up-to-date all the time. In the event of a tie in an age group, the lowest time ranks higher. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confused | Excel Worksheet Functions | |||
Confused | New Users to Excel | |||
confused,please help | Excel Discussion (Misc queries) | |||
:S confused :S | Excel Discussion (Misc queries) | |||
:S confused :S | Charts and Charting in Excel |