+ Reply to Thread
Results 1 to 4 of 4

Fill cells skipping columns

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    3

    Fill cells skipping columns

    Hi guys,,,
    if I want to pass columns when filling cells, what's the formula for doing it?
    for example I want to enter data in A1, A2, A3 (rows) or A1, B1, C1 (column) while the linked cell is D1, G1, J1
    Thank you guys.....
    regards
    Last edited by ASRAJO; 04-06-2020 at 11:30 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Fill cells skipping columns

    at D1
    =IF(MOD((COLUMN(A:A)+2),3)=0,INDEX($A1:$C1,D8),"")
    copy from D1 To G1

  3. #3
    Registered User
    Join Date
    04-06-2020
    Location
    INDONESIA
    MS-Off Ver
    2016
    Posts
    3

    Re: Fill cells skipping columns

    what I mean is I want to use fillings with drag filling which is different from the lookup concept.
    a simple example is like in the picture
    btw thanks for the answer ghozi

    screenshot => "drive.google.com/open?id=1q6MMkKFdwRrxvTGBFHSTSL9u_sKGNzhG"

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

    Re: Fill cells skipping columns

    Or better still following the yellow banner at the top of this page and giving us the data and the expected solution

+ 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. Replies: 1
    Last Post: 04-30-2017, 02:28 PM
  2. Replies: 1
    Last Post: 05-21-2014, 04:30 PM
  3. Fill down into merged cells without skipping rows
    By dancing-shadow in forum Excel General
    Replies: 8
    Last Post: 11-04-2013, 08:08 AM
  4. [SOLVED] Drag/Fill column while skipping multiple reference rows in another worksheet
    By chandlerrw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2013, 07:59 PM
  5. Fill down a column using right(), skipping rows, VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2012, 04:30 PM
  6. fill down column skipping cell references
    By buckfran in forum Excel General
    Replies: 3
    Last Post: 08-11-2009, 04:19 PM
  7. Fill down into merged cells without skipping rows
    By jamesozzie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2007, 10:03 AM

Tags for this Thread

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