+ Reply to Thread
Results 1 to 6 of 6

excel offset

  1. #1
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    57

    excel offset

    Hi excel experts

    here i stuck with one query and when i am using offset it is not working so please help me in this regard and thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,885

    Re: excel offset

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,053

    Re: excel offset

    I agree with the above, what are the expected results? 1600 for A? An answer can be calculated, but it is much more convoluted than with a helper column, and if it stopped working would be harder for you to fix. It would also be much easier if the answers were in c4 c8 and c11

  4. #4
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    57

    Re: excel offset

    excel experts


    i want add whole A still B without helping coloum

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,698

    Re: excel offset

    Try in D6:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    57

    Re: excel offset

    i try thanks bro

+ 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. Offset Alters Entire Range, Need To Offset A Single Cell
    By Genus Max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2020, 10:47 AM
  2. Select offset variable offset cells
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2014, 06:12 AM
  3. Replies: 3
    Last Post: 06-01-2014, 10:26 AM
  4. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  5. Reformatting - insert formula with offset, then offset to next cell
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2011, 05:41 AM
  6. Replies: 7
    Last Post: 11-04-2008, 06:41 AM
  7. Help on how to use Offset in Excel
    By petros89 in forum Excel General
    Replies: 1
    Last Post: 10-07-2005, 07:05 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