The OFFSET function can help. Also INDIRECT or INDEX, depending on your
application. An expression such as

OFFSET(A1:A10,ROW()*10,0)

can refer to groups of ranges like you specify.

HTH
Kostis Vezerides

Pradeep wrote:
Hi,

I would like to split data in a table into ranges; say 1-10, 11-20 etc.
These ranges may also change based on the data cut required. Is there a way
to dynamically get the range in which the data falls in the table?