| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset On 2 Columns
I am using the following to name a range with 1 column, so it expands
dynamically. But how do I do this for 2 columns of data? Both columns will have data filled in the exact same rows. =OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset On 2 Columns
=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,2)
-- Regards, Peo Sjoblom "Derek Hart" wrote in message ... I am using the following to name a range with 1 column, so it expands dynamically. But how do I do this for 2 columns of data? Both columns will have data filled in the exact same rows. =OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Offset On 2 Columns
Am I missing something or not understanding. ,2 instead of ,1 for col a & b
based on length of col a. =OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Derek Hart" wrote in message ... I am using the following to name a range with 1 column, so it expands dynamically. But how do I do this for 2 columns of data? Both columns will have data filled in the exact same rows. =OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET for multiple columns & combobox format | Charts and Charting in Excel | |||
| SUM OFFSET COLUMNS | Excel Worksheet Functions | |||
| creating columns with data from offset rows | Excel Discussion (Misc queries) | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Vlookup/match/offset over multiple columns of lable | Excel Discussion (Misc queries) | |||
Hybrid Mode
