+ Reply to Thread
Results 1 to 2 of 2

can't get OFFSET to work in this case?! driving me crazy :)

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Israel
    MS-Off Ver
    Excel 2013
    Posts
    70

    can't get OFFSET to work in this case?! driving me crazy :)

    hi all

    I have a pretty large spreadsheet with 30 columns containing sets of Tests results and then another 10 columns, lets call these sets of Exams results (just so we speak the same language).
    I need the R^2 (RSQ function) between each Test and all the Exams (or all the exams and every Tests )

    doing it manually will take forever, so I'm trying to use the OFFSET function to make excel move the range of Exams result 1 column to the right every time I copy/drag down.. I hope I'm being clear.. for some reason I keep getting #NA errors! please can someone just take a look? the "Exams" are the colored columns on the right end, and "Tests" are columns C:AM


    to maintain order and know the RSQ of what two sets of data I'm seeing I want the output to look like
    Please Login or Register  to view this content.
    I strongly advice you to zoom out a bit so you can see the structure and also my example, explanations and FAILED attempt down below

    I'd be glad to provide explanations. I really need this. Thank you guys.


    thanks a lot in advance guys! lihi22.xlsx

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,508

    Re: can't get OFFSET to work in this case?! driving me crazy :)

    Hi,

    The range sizes for your known_y's and known_x's must be of the same size.

    Currently, you are using the OFFSET function with a height of 15 for the former and AN35:AN50 (which is 16 rows high) for the latter. Change the height variable to 16 in the OFFSET function.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. This is driving me crazy!!
    By rtausch in forum Excel General
    Replies: 0
    Last Post: 10-15-2008, 06:33 PM
  2. please please help driving me crazy
    By jilly jess in forum Excel General
    Replies: 1
    Last Post: 01-14-2007, 09:59 AM
  3. Driving me crazy!
    By RobEdgeler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2005, 05:19 PM
  4. Vlookup in VBA - Driving me crazy
    By James in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2005, 08:05 PM
  5. macro driving me crazy
    By bondcrash in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-16-2005, 07:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1