- Excel Desktop Client new !
AUTO LIST automatically generates a sequential LIST of numbers or letters.
Type: specifies the type of list to generate and Size: sets the length.
|Type:||Type of list (Integer, Alphabetical Upper Case, Alphabetical Lower Case, Spreadsheet)|
|Size:||Number of values to create in the LIST, Expressions allowed|
When a size greater than 26 is specified for an alphabetical type AUTO LIST, the value after Z resets back to A. This action repeats every time Z is surpassed. For a spreadsheet type, the values after Z are AA, AB, AC, etc., and will reset back to A after ZZ is surpassed.