| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling series
I want to fill series like this
1111 1112 1113 1114 1115 1116 1120 1121 1123...... and so on. The numbers increase by 1 until it reaches 6 as the last digit. Then it increases by 4. Any idea how to pull this off? I thought I had it nailed, but the numbers just do not add up. B. rgds Zulupiper |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling series
Hi
Enter in A1, 1110 In A2 enter =IF(--RIGHT(A1)=6,A1+4,A1+1) and fill down as far as required. If you want to "fix" the values, copy column APaste SpecialValues -- Regards Roger Govier "Zulupiper" wrote in message ... I want to fill series like this 1111 1112 1113 1114 1115 1116 1120 1121 1123...... and so on. The numbers increase by 1 until it reaches 6 as the last digit. Then it increases by 4. Any idea how to pull this off? I thought I had it nailed, but the numbers just do not add up. B. rgds Zulupiper |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling series
Thanks a million.
Sure solved my problem. Best Regards ZuluPiper. "Roger Govier" wrote: Hi Enter in A1, 1110 In A2 enter =IF(--RIGHT(A1)=6,A1+4,A1+1) and fill down as far as required. If you want to "fix" the values, copy column APaste SpecialValues -- Regards Roger Govier "Zulupiper" wrote in message ... I want to fill series like this 1111 1112 1113 1114 1115 1116 1120 1121 1123...... and so on. The numbers increase by 1 until it reaches 6 as the last digit. Then it increases by 4. Any idea how to pull this off? I thought I had it nailed, but the numbers just do not add up. B. rgds Zulupiper |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling a series into a non-empty column | Excel Worksheet Functions | |||
| Filling a series down a page | Excel Discussion (Misc queries) | |||
| Filling a series | Excel Discussion (Misc queries) | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| filling a series | Excel Discussion (Misc queries) | |||
Linear Mode
