| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag-filling a formula Array
I want to create a summary of data and have a solid formula (using such
formula's as match, lookup, and vlookup). Unfortunately, when I try to drag these formulas, the arrays that they correspond to are not the ones I desire. For example, my original array is A10:A20 and want the next one to be A20:A30, but when I start dragging it goes to A11:A21. Even with multiple cells manually edited then dragged, it still doesn't want to do it in the format I want. Anyone?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with filling in an array formula | Excel Discussion (Misc queries) | |||
| Filling Source Data Array with Decimal Values | Charts and Charting in Excel | |||
| Filling a List Box in Excel from an Array | Excel Discussion (Misc queries) | |||
| Filling excel entire row/column instead of single cell from an array | Excel Worksheet Functions | |||
| Filling an array with data | Excel Worksheet Functions | |||
Threaded Mode
