Solved

changing dynamic range

Posted on 2011-02-11
3
297 Views
Last Modified: 2012-05-11
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
Comment
Question by:Stephen Byrom
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 34877212
Assuming data in column B is continuous then something like:

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

Chris
0
 
LVL 1

Author Closing Comment

by:Stephen Byrom
ID: 34877224
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
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34877230
Glad to help but thank you for the prompt grade and comment.

Chris
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now