S
silver
I've got 8 ranges all setup as dynamic with the following formula:
=OFFSET(sheet!$A$2,0,0,COUNTA(sheet!$A:$A)-1,1)
6 of the 8 ranges are having their ranges defined properly.
I don't know why the other two are not.
I've attached a pic of how they're laid out.
When I go to the Names list and click on the formula for Column B it
includes the two empty cells below the last number. Advanced filter
fails, probably because of that. The formula is identical to the others
that work...
When I go to the Names list and test the range for Column G, the range
is appropriately identified, but the filter fails again.
All the other columns work.
I'm probably not being as clear as I can be. Please let me know what
other info you need.
+-------------------------------------------------------------------+
|Filename: sheet.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4990 |
+-------------------------------------------------------------------+
=OFFSET(sheet!$A$2,0,0,COUNTA(sheet!$A:$A)-1,1)
6 of the 8 ranges are having their ranges defined properly.
I don't know why the other two are not.
I've attached a pic of how they're laid out.
When I go to the Names list and click on the formula for Column B it
includes the two empty cells below the last number. Advanced filter
fails, probably because of that. The formula is identical to the others
that work...
When I go to the Names list and test the range for Column G, the range
is appropriately identified, but the filter fails again.
All the other columns work.
I'm probably not being as clear as I can be. Please let me know what
other info you need.
+-------------------------------------------------------------------+
|Filename: sheet.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4990 |
+-------------------------------------------------------------------+