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