Contents - Index


Fill Order/Group Column Dialog Box



This dialog box is a time saving feature designed to save having to type values into the Order or Group columns of the currently selected tab in the Data window.  It can only be used when the data is in a patterned order.  To specific the values to enter into the selected column, specify:

Column to Fill Radio Group Box:  Select whether to fill Order column or Group column.

Use Numbers 1 to Combo Box:  Enter the number of subgroups when filling the Order column or the number of groups when filling the Group column.  Must be an integer of 2 or more.

List Each Value ? Times Combo Box:  Repeat each value the specified number of times before going to the next number.  Must be an integer of 1 or more.

Repeat Whole Sequence ? Times Combo Box:  Repeat the whole sequence specified by the previous 2 controls the specified number of times.  Must be an integer of 1 or more.

Click the Fill Column button to generate the values for the selected column in the currently selected tab of the Data window.  If the tab already contains data, you are prompted to make sure it is OK to overwrite the data.  To exit without generating any values, click the Cancel button or press the Esc key.

This dialog box is displayed by clicking Fill Order/Group Column button in the Data window.

In the example above, the follow column of data is generated for Order:

1
1
1
1
1
2
2
2
2
2
3
3
3
3
3
1
1
1
1
1
2
2
2
2
2
3
3
3
3
3