Re: OFFSET Formula Trouble

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Wed, 18 Aug 2004 15:43:58 +0200

Hi
use:
=OFFSET('NM On time'!$B$25,0,0,1,9)

But if you hardcode the range this way why not simply use:
$B$25:$J$25

or do you mean:
=OFFSET('NM On time'!$B$25,0,0,1,COUNTA('NM On time'!$B$25:$J$25)) 

--
Regards
Frank Kabel
Frankfurt, Germany
"Naoki >" <<Naoki.1b6s7y@excelforum-nospam.com> schrieb im Newsbeitrag
news:Naoki.1b6s7y@excelforum-nospam.com...
> Maybe someone can help me with this formula:
>
> =OFFSET('NM On time'!$B$25,0,0,COUNTA('NM On time'!$B$25:$J$25),9)
>
> I have defined a name for this formula, to utilize as a criteria
range
> in a graph.  Don't ask me why I can't just grab the data I need, I'm
> doing this for someone else, has something to do with altering the
> data.  Anyways, my problem is that this formula is meant to grab a
> "header" for a list of store numbers like so...
>
> 95 | 60 | 46 | 50 | 8 | 98 | 90 | 65 | 54
>
> There are nine store numbers, 9 columns across.
>
> Obviously, there is just 1 row containing this header.
>
> The formula I am using is correctly calling the 9 columns I need, but
> it is ALSO counting 9 rows down, so I have a 9x9 area being called
from
> this formula.  Basically, I want a 9x1 area, 9 columns, 1 row.
Changing
> the final 9 value in my equation to 8 reduces the number of columns
to
> 8, so I know that that value SHOULD be 9, and I can't seem to think
why
> its also calling (coincidentally) 9 rows.  Any help is appreciated!
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • OFFSET Formula Trouble
    ... Don't ask me why I can't just grab the data I need, ... There are nine store numbers, ... there is just 1 row containing this header. ... The formula I am using is correctly calling the 9 columns I need, ...
    (microsoft.public.excel.misc)
  • Re: PING > dawzaG
    ... >> happening in the Org header and, would you believe, in the date ... ventilation; avoid extreme temperatures and store in a cool, ... away from open flames, naked flames and old flames; avoid inhaling fumes; ...
    (alt.os.windows-xp)
  • Re: Hash question ...
    ... header of the file. ... When a user enters an incorrect passphrase, ... if I generate an encryption key with the ... could I safely store the SHA of the passphrase ...
    (sci.crypt)
  • PING > dawzaG
    ... header and, would you believe, in the date header as well. ... ventilation; avoid extreme temperatures and store in a cool, ... away from open flames, naked flames and old flames; avoid inhaling fumes; ...
    (alt.os.windows-xp)
  • Re: databases
    ... because i only know how to store text in the database. ... which command should i use (php) in order to retrieve these ... according to file extension and making the above header() call relative to ...
    (comp.lang.php)