How do I split my data into ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
Conditional formatting on a dynamic range - workaround 1
Dynamic 5-week date range & SUMPRODUCT formulas 0
Dynamic Named Ranges 3
Split data in field on character return 0
Grouping a range in pivot without standard to from 1
Count time formatted data within range 1
Count Filtered Visible Items that Match Numeric Criteria between two ranges 4

Back
Top