| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Partition data range by an indicator variable
The formula =OFFSET(Data!$R$1,1,0,COUNTA(Data!$R:$R)-1) returns the array of
data in column R. As I add data points, the size of the array changes to match all of the data entered. I would like to subset the data range into non-overlaping ranges by using an indicator variable (1, 2, ...) in a different column. Thanks, Arne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Partition + Grouping | Excel Programming | |||
| access partition function | Excel Worksheet Functions | |||
| Range of data is variable... | Charts and Charting in Excel | |||
| Set Data Range by Variable | Excel Discussion (Misc queries) | |||
| how to format ntfs partition | Charts and Charting in Excel | |||
Threaded Mode
