OFFSET Formula Trouble

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

Date: Wed, 18 Aug 2004 08:37:12 -0500

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

  • Re: OFFSET Formula Trouble
    ... Don't ask me why I can't just grab the data I need, ... > "header" for a list of store numbers like so... ... 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)