Re: OFFSET Formula Trouble

From: Naoki (Naoki.1b6u5n_at_excelforum-nospam.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 09:19:01 -0500

Thank you again, I knew it was very simple (I think the trouble is the
assignments I'm recieving are half-correct formulas with too much
information that I try to work from).

So I've used your first formula for my criteria range.

Now, for the actual plotted data, I need a formuliac solution that
references the named range "we" just made (because its the same size as
the data I need to plot), but I need to have the chart always reference
the last row before data was input (this being the most recent "week").
I know I've asked similar questions before, but now that I have the
criteria range named, how do I utilize that to get the last row of
data?

For instance:

=OFFSET(NMOnTimeWeekly,1,)

Would go to the next row, which is week 1, well.. I'm in week 32 now,
and I'd like the chart to always reference the final row without going
having to go into the chart each week. Any suggestions? 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: OFFSET Formula Trouble
    ... > assignments I'm recieving are half-correct formulas with too much ... > So I've used your first formula for my criteria range. ... > and I'd like the chart to always reference the final row without ...
    (microsoft.public.excel.misc)
  • Re: Understanding the History of Ancient Israel
    ... POST THE CHART ITSELF for everybody to see and interpret ... That's the reference. ... Usshikin thinks that archaeologists need professional ... unwarranted opinion that Ussishkin just slipped and said by mistake? ...
    (sci.archaeology)
  • Re: For MATT and DIGGER: VAT4956 FRAUD, How interested are you?
    ... If you are talking about the chart. ... Each reference individually having the same potential ... It is basically calling c. 871 BCE ... dating for the Assyrian Period, right or wrong, coincidentally or correctly, ...
    (sci.archaeology)
  • Re: Understanding the History of Ancient Israel
    ... POST THE CHART ITSELF for everybody to see and interpret ... That's the reference. ... If my chronology is wrong, ... Usshikin thinks that archaeologists need professional ...
    (sci.archaeology)
  • Re: Copy Chart from Excel to Word using VBA
    ... ' Reference existing instance of Word ... ' Paste chart at cursor position ... Jon Peltier, Microsoft Excel MVP ... Active Word Document I get an error message that indicates that the ...
    (microsoft.public.excel.programming)