Dynamic Range Names Using IF?

[jayb3369]

I want to create a dynamic range name for a single column. The column will contain dates. The number of rows will change every month when the data is cleared and new data is pasted in. I want to refer to the entire column by a dynamic range name, but I want to end the range before the year 2011. I don't want to include any dates past 2010 in the range.

The column will be sorted in ascending order.

I have no idea how to do this. Any ideas?

Thanks

Jayb3369

 

[JonRowland]

jayb3369

You need to create a dynamic range name.

So you need to define a new Name and enter
= OFFSET(SheetName!$A$1,0,0,COUNTA(SheetName!$A:$A),COUNTA(SheetName!$1:$1))

As the data increases the range will resize.

HTH
Jon

 

[jayb3369]

Thanks, but that's not quite what I want to do. I don't want to include all the data in the range. Every month, the amount of data (a column of dates) will be different. But I want the dynamic range to include only those dates in 2010. The dates will be sorted in ascending order.