Formulas & Dyanmics ranges

[HunterN]

Hi!

I am having trouble thinking of how this works!

I need a range that can change dynamically. And I need to be able to enter this range in the formula as the second value.

Say my spreadsheet lists 10 projects, in cells F7 thru F16. The formula is: =F7:F16.
But next time I add a project to the list and the range has increased by one, how do I define the second value as a dynamic range? And use it in the formula?

Thanks, to whom ever can answer this. Nancy

[sann0638]

there's lots on this previously. try a search on 'dynamic ranges' or somesuch.

[Ricky Morris]

See the following site.

http://www.ozgrid.com/Excel/DynamicRanges.htm

[Aladin Akyurek]

On 2002-05-22 08:32, HunterN wrote:
Hi!

I am having trouble thinking of how this works!

I need a range that can change dynamically. And I need to be able to enter this range in the formula as the second value.

Say my spreadsheet lists 10 projects, in cells F7 thru F16. The formula is: =F7:F16.
But next time I add a project to the list and the range has increased by one, how do I define the second value as a dynamic range? And use it in the formula?

Thanks, to whom ever can answer this. Nancy

How do you code a project -- as a number maybe? Is there any other data next to the current project list in F7:F16 that that changes/grows together with this list?

[HunterN]

The columns to the right and left of the
project number has data in it also.
The projects are listed by Project Number.

Thanks, Nancy

[Aladin Akyurek]

On 2002-05-22 10:13, HunterN wrote:
The columns to the right and left of the
project number has data in it also.
The projects are listed by Project Number.

Thanks, Nancy

That sounds good. Is a Project Number really a number for which the following holds:

=ISNUMBER(a-project-number) ==> TRUE

Do the columns left and right contain numbers or dates or hours?

Aladin