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