conditional named dynamic ranges

  • Thread starter Thread starter matthew701
  • Start date Start date
M

matthew701

I've use the offset function with great success to define named dynamic
ranges, but I'm now trying to only include certain rows in the range.
The formula I use currently looks like this:

=OFFSET('NARD Listing'!$A$1,0,0,COUNTA('NARD Listing'!$A:$A),8)

but I am unable to figure out how to only include rows that have '2005'
as a value in column D, as an example, in the named range.

thanks for any help!

Matthew
(using Excel 2000)
 
Matthew,

I don't know of a dynamic way you can get a reference to selected rows, such
as with OFFSET. I think you'll have to do it procedurally, like with Data -
Advanced Filter, which you'd set up manually (or via a macro). That can
give you the selected records you want.
 
Back
Top