• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

changing dynamic range

Hi there,
I can make a range dynamic by creating a table but i want to make a dynamic range that is the last 8 rows of a column, column B for example. The column is added to each week and i need to always refer to the last 8 rows, so that i can name the range and set it as a series in a chart.
As always your time is appreciated.
0
Stephen Byrom
Asked:
Stephen Byrom
  • 2
1 Solution
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Assuming data in column B is continuous then something like:

=OFFSET(Sheet1!$B$1,COUNTA(Sheet1!$B:$B)-8,0,8,1)

Chris
0
 
Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks for the quick response, I tried the offset thing but just couldnt get it to work. Yours, of course has the correct syntax.
Thanks again for your help
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Glad to help but thank you for the prompt grade and comment.

Chris
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now