Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Offset to name a range
I have a worksheet that filters data to
b17 through k(row number will vary) can someone tell me what is wrong with this function? I admit i have a rough time with offset! =OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2)) Thank you-Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
|
|||
|
|||
Hi Jennifer,
=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.! $2:$2)) write the count-formlas in cells and check the result they give. are they doing what you want? arno |
#3
|
|||
|
|||
When i test it selects column b:c and etends about 8 rows past the pt. of data.
-- Though daily learning, I LOVE EXCEL! Jennifer "Jennifer" wrote: I have a worksheet that filters data to b17 through k(row number will vary) can someone tell me what is wrong with this function? I admit i have a rough time with offset! =OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2)) Thank you-Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
#4
|
|||
|
|||
Jennifer,
This seems to work for me =OFFSET('GwrStmts '!$B$17,0,0,COUNTA('GwrStmts '!$B:$B,1),COUNTA('GwrStmts '!$2:$2)) If the sheet really does have a trailing space in the name, you need apostrophes -- HTH Bob Phillips "Jennifer" wrote in message ... I have a worksheet that filters data to b17 through k(row number will vary) can someone tell me what is wrong with this function? I admit i have a rough time with offset! =OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B ,1),COUNTA(GwrStmts.!$2:$2 )) Thank you-Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Labelling a row so it can be used as an offset for sum, difference or range | Excel Discussion (Misc queries) | |||
dynamic range / offset | Excel Worksheet Functions | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Define Range with an offset | Excel Discussion (Misc queries) |