Re: OFFSET Formula Trouble

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 17:08:24 +0200

Hi
try:
=OFFSET('NM On time'!$B$25,COUNTA('NM On time'!$B$25:$B$1000)-1,0,1,9) 

--
Regards
Frank Kabel
Frankfurt, Germany
"Naoki >" <<Naoki.1b6u5n@excelforum-nospam.com> schrieb im Newsbeitrag
news:Naoki.1b6u5n@excelforum-nospam.com...
> 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. ... the data I need to plot), but I need to have the chart always reference ...
    (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)