conditional named dynamic ranges

[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)

 

[Earl Kiosterud]

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.