11.1 Simple grouping

 

Here below is a data table:

imagepng

We want to group by Class, and calculate the average score of each subject of each class:

=spl("=E(?1).groups(Class;avg(Maths):Maths,avg(English):English,avg(PE):PE)",A1:E12)

imagepng


esProc Desktop and Excel Processing
10.14 Rank in group
11.2 Group by combination of multiple columns