Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List top five results based on age grouping
Have a sheet called TOTALS set out as
A5 B6 C5 to V5 W5 X5 name club ind events total age group Fred aaaa 22 10 Anne bbbb 30 12 Tim aaaa 28 10 This sheet list everyone and every age group. On a new sheet need to list Top Five Point Scorers for each Age Group eg 10 yrs 1 Name Club Points 2 3 4 5 Prefer a function other than filter or pivot table as results are updated and automatically and will be used by others. Many thanks Loza |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping rows based on header cells | Excel Discussion (Misc queries) | |||
Assigning a Value based on Results | Excel Worksheet Functions | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Random Grouping/Fixture List?? | Excel Worksheet Functions | |||
Grouping the results of Networkdays | Excel Discussion (Misc queries) |