Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPBYBIN(<number|date>;<integer>)

Description

This function groups selected values into bins created at a specified size. The second argument in the function is the size of the bin.

This is a group series function.

Example

Data Source Sheet:

Values
456
789
324
419
738

 

Calculation Sheet 1:

The results column on the calculation sheet uses the GROUPBYBIN function to group the values by the bin size 100.

GROUPBYBIN(#DataSourceSheet!Values;100)

Results
300
400
700
 
 

GROUPBYBIN() can not reference a column from the same sheet where it is being performed.

  • No labels