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.
Please sign in to leave a comment.