How to Create a Range of Integers in a Column

Goal

Creating a new list of integers in a column within a Datameer worksheet.

 

Learn

For example, if one wanted to calculate percentiles from 0 through 99, this technique could be used to create a column that contains row records of 0 through 99.

Formula:

=EXPAND(RANGE(0;99))

This formula uses two functions. The function RANGE takes two arguments and builds a list of integers between the starting and ending value (inclusively). The EXPAND function takes the generated list and creates a row for each element in the list.