| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill and expand
I have information exported from an accounting system into an Excel
spreadsheet. The export has 3 columns; the first column contains the value of the first data of the range; the second column contains the end value of the range; the third column shows a percentage rate applicable to all values within the range. e.g C00123 C00125 15% C00128 C00130 100% Note there is a gap between the end value at column 2 in row 1 and the next value in column 1 of row2. The intervening range has a default percentage rate of 0%. Is there a way to expand and fill the/a spreadsheet so that the result looks like this: C00123 15% C00124 15% C00125 15% C00126 0% C00127 0% C00128 100% C00129 100% C00130 100% C00131 0% et seq I would greatly appreciate any help. -- Geoff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Threaded Mode
