Dynamic Range in EXCEL

[truitt20]

Ok - I have a problem here. I am trying to create a dynamic defined range using the offset & count functions, but I am not sure how to grab the range I am looking for. I have column C populated with a whole bunch of numbers. Each month we add additional numbers to the column, and I want a range that is based off of the last number & the trailing 375 cells (the 375 cells above the last number). Would the formula be something like:

=OFFSET('P&L (Daily)'!$C:$C,-375,0,COUNT('P&L (Daily)'!$C:$C),1)

?

Thanks for your help!

jt

 

[SkipVought]

Hi,

[tt]
=OFFSET(
'P&L (Daily)'!$C$1,
COUNTA('P&L (Daily)'!$C:$C)-374,
0,
375,
1)
[/tt]
assuming that EVERY CELL in column C in your table has a value.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[truitt20]

Perfect! thank you