How to Create a Range of Integers in a Column


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



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.



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.