ExcelBanter - How do I split my data into ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I split my data into ranges (https://www.excelbanter.com/excel-worksheet-functions/126269-how-do-i-split-my-data-into-ranges.html)

Pradeep

How do I split my data into ranges

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?

vezerid

How do I split my data into ranges

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?

All times are GMT +1. The time now is 05:36 AM.