Using Offset to name a range

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

Guest

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
 
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
 
When i test it selects column b:c and etends about 8 rows past the pt. of data.
 
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
 
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

Another coping and pasting macro 1
OFFSET with a condition 0
Offset/COUNTA problems 4
Drop Down with dynamic named range offsheet source list 14
Range error 1
offset problem with finding last entry in a row 1
Dependent drop down dynamic range formula, off sheet. 7
OFFSET FUNCTIONS IN A CHART, FORMULA ERROR KEEPS COMING UP. 1

Back
Top