Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I embed an OFFSET function in a SERIES function on MS EXCEL?
Using a formula, I'm trying to create a graph based on data from other sheets. For this, I will need to put an OFFSET function in my range rather than directly stating the cell reference. However, whenevr I try to do this, it gives me an error.
Is there a way to bypass this error and somehow get an offset equation to be put into a series function?
An example:
=SERIES("Title",,$F$6:OFFSET(F7, -1), 1) will create an error. How can I do this task without creating an error?
2 Answers
- C MastersLv 61 decade agoFavorite Answer
I'm not quite sure what you need the OFFSET for but it will not work without at least 3 arguments
$F$6:OFFSET(F7, -1) only has 2 of the 3 arguments complete which may be why you are getting an error
OFFSET(reference,rows,cols)
hope that helps get you unstuck
- doreenLv 44 years ago
here ought to offer you the final unused cellular in row a million and place the date in that cellular. dim startcell as selection set startcell = selection("IV1").end(xltoleft).offset(0,a million) startcell.value = Date
