Create a simple set of numbers

Calc > Make Patterned Data > Simple Set of Numbers

Complete the following steps to fill a column with a pattern of equally-spaced numbers, such as the numbers 1 through 100, or five sets of 1, 2, and 3.

  1. In Store patterned data in, enter a column number (for example, C1) or column name. If the name contains spaces, enclose the name in single quotation marks.
  2. Enter the sequence of numbers in the pattern.
    1. In From first value, enter the first value of the sequence. You can enter stored constants (K) instead of numbers.
    2. In To last value, enter the last possible value of the sequence.
    3. In In steps of, enter the increment for the sequence.
  3. Enter the repeat information for the pattern.
    1. In Number of times to list each value, enter the number of consecutive times to list each value in the sequence.
    2. In Number of times to list the sequence, enter the number of times to repeat the entire sequence.

For example, these settings create the following column of data.

  • From first value: 10
  • To last value: 14
  • In steps of: 2
  • Number of times to list each value: 2
  • Number of times to list the sequence: 3
C1
Numbers
10
10
12
12
14
14
10
10
12
12
14
14
10
10
12
12
14
14
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy