| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Concatenated List with Incremental Values
I would like to create a list by concatenating two values. The first
value is a 4-letter alpha code selected from a control named DropDown1, and the other is an incrementing number starting with the value in cell A9 and ending with A11, always 1 or 2-digit numbers. Example: DropDown1 value= ABCD A9 = 7 A11 = 10 Desired output is a list starting in cell A14: ABCD07 ABCD08 ABCD09 ABCD10 I've been at this for hours, and don't seem to be on the right track. Any direction would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| How do I create incremental numbers on an order form? | Excel Discussion (Misc queries) | |||
| create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10) | Charts and Charting in Excel | |||
Threaded Mode
