+ Reply to Thread
Results 1 to 3 of 3

Formula Dragging and skipping cells

  1. #1
    Registered User
    Join Date
    12-04-2017
    Location
    Cambridge, Ohio
    MS-Off Ver
    2007
    Posts
    1

    Formula Dragging and skipping cells

    ON Sheet tab "CTE" B3, I am wanting to return the value from sheet tab "running tab" F18
    ON Sheet tab "CTE" C3, I am wanting to return the value from sheet tab "running tab" K18

    So I am skipping 5 columns of info so the cells would look like this when dragging to the right:

    ..........B3..............................C3......................... D3...........................E3
    ='running tab'!f18 , ='running tab'!k18 , ='running tab'!p18 , ='running tab'!u18......
    Last edited by Raiderbuck11; 12-04-2017 at 11:20 AM.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Formula Dragging and skipping cells

    can you please attach a sample sheet, so that you can get enough help on this.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula Dragging and skipping cells

    Hi Raiderbuck11. Welcome to the forum.

    Try this in B3 of "CTE" and fill to the right.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ 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. [SOLVED] Dragging formula skipping rows
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2015, 07:38 AM
  2. Skipping 13 rows while dragging a formula
    By Carlos90 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-17-2013, 01:01 AM
  3. [SOLVED] Skipping a column when dragging formula
    By bharbir in forum Excel General
    Replies: 4
    Last Post: 08-05-2013, 01:51 AM
  4. Skipping 5 rows and then dragging formula down
    By Zack99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2013, 04:06 PM
  5. dragging "rank order" function down, skipping grouped cells
    By theletterh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2012, 06:52 PM
  6. Skipping Every 5th Row and Dragging Down To Get New Data
    By seannydj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2012, 10:00 PM
  7. Dragging Formulas - Skipping Referenced Cells
    By markpratt in forum Excel General
    Replies: 2
    Last Post: 11-03-2011, 10:03 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