In row1 use
INDIRECT("A"&(ROW()*10)&":A"&(ROW()+1)*10)
whereever you had A10:A20
and then copy the formula down...

Do note that A10:A20, A20:A30 are overlapping or did you mean A11:A20,
A21:A30,...?

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jacob C." wrote:

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??