Results 1 to 4 of 4

OFFSET formula difficulties

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2018
    Location
    amsterdam
    MS-Off Ver
    excel 2016
    Posts
    8

    OFFSET formula difficulties

    Hi!

    I'm having difficulties with the offset formula. I have a dataset that has data across rows, and I want every value from the 11th column in one row, starting in cell T3. I've tried using the formula as below:

    =OFFSET(Data!$T$3;0;(COLUMN(Data!A4)-1)*11)

    This gives me the first value as in T4, however, when I copy it down to get the value 11 column over from T3, it still gives me the value in T3. I'm not sure where my error is located.

    I would appreciate any help you might be able to offer.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] fill down vlookup formula difficulties
    By scross in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-15-2018, 06:22 PM
  2. To find a number according to the table (not using IF)
    By sarstep1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2017, 10:13 AM
  3. Difficulties adapting an intercept formula
    By ndw123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2013, 05:01 PM
  4. Difficulties with sumproduct/choose formula
    By amartino44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2013, 06:41 PM
  5. Having difficulties with Networkdays formula in my macro
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2012, 04:13 PM
  6. Difficulties with a large formula
    By SweetSin80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2006, 04:45 PM
  7. RE: Difficulties with a large formula
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2006, 04:40 PM

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