| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling down text in increments of three
How can I fill a worksheet all the way down with the following:
A1=2 steps A2=2 steps A3=2 steps A4=3 steps A5=3 steps A6=3 steps A7=4 steps A8=4 steps A9=4 steps And so on, each in increments of three, all the way down the sheet. I asked the same question yesterday for numbers only without text and got some excellent formulas for that. Today I specifically need to enter the number and the text in the same cell - "4 steps". Thanks. Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filling down a formula using =TEXT() | Excel Discussion (Misc queries) | |||
| Filling cells with Word text characters | Excel Discussion (Misc queries) | |||
| Filling Text from Another File | Excel Worksheet Functions | |||
| increments | Excel Discussion (Misc queries) | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
Threaded Mode
