+ Reply to Thread
Results 1 to 6 of 6

excel offset

  1. 10-22-2020, 03:17 AM #1
    beepetark
    beepetark is offline
    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
    Reply With QuoteRegister To Reply
  2. 10-22-2020, 03:19 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    13,015

    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!
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 10-22-2020, 03:25 AM #3
    davsth
    davsth is offline
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,061

    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
    Reply With QuoteRegister To Reply
  4. 10-22-2020, 03:32 AM #4
    beepetark
    beepetark is offline
    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
    Reply With QuoteRegister To Reply
  5. 10-22-2020, 05:25 AM #5
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,840

    Re: excel offset

    Try in D6:
    Please Login or Register  to view this content.
    Quang PT
    How To Learn Excel Effectively by Helping People
    Reply With QuoteRegister To Reply
  6. 10-22-2020, 05:43 AM #6
    beepetark
    beepetark is offline
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    57

    Re: excel offset

    i try thanks bro
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Using OFFSET function to return the value from another cell with row and column offset
    By engine44 in forum Excel Formulas & Functions
    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. IF and OFFSET: how to OFFSET only if cell has a value in it (follows previous post)
    By bubastisbastet in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1