11.4 Group by segment

 

Here below is a data table:

imagepng

We want to count the number of people in each of the following score segments respectively: below 50, 50-60, 60-70, 70-80, 80-90 and above 90.

=spl("=E(?1).groups(if(Score<50:""<50"",Score>=50 && Score<60:""50-60"",Score>=60 && Score<70:""60-70"",Score>=70 && Score<80:""70-80"",Score>=80 && Score<90:""80-90"";"">=90""):Score;count(1):Num)",A1:C25)

imagepng


esProc Desktop and Excel Processing
11.3 Group by expression
11.5 Enumeration grouping